X-Git-Url: http://git.kpe.io/?a=blobdiff_plain;f=doc%2Fref-fdml.xml;fp=doc%2Fref-fdml.xml;h=a5162ff6c1b3801e054353b6bd28556e2d053d4d;hb=78489032c6f66ce666ffe5e2e726503b61b94616;hp=c512cdb020f9d0829e16bfe5396a1d7a26f52e51;hpb=16cede958e7f229e2502ab6309591e344bee54f5;p=clsql.git
diff --git a/doc/ref-fdml.xml b/doc/ref-fdml.xml
index c512cdb..a5162ff 100644
--- a/doc/ref-fdml.xml
+++ b/doc/ref-fdml.xml
@@ -1188,6 +1188,22 @@ ID FORENAME SURNAME EMAIL
+
+ limit
+
+
+ A non-negative integer.
+
+
+
+
+ offset
+
+
+ A non-negative integer.
+
+
+
order-by
@@ -1341,8 +1357,8 @@ ID FORENAME SURNAME EMAIL
specified lisp type. The keyword arguments
all, distinct,
from, group-by,
- having,
- order-by,
+ having, limit,
+ offset, order-by,
set-operation and
where are used to specify, using the
symbolic SQL syntax, the corresponding components of the SQL
@@ -1423,7 +1439,7 @@ ID FORENAME SURNAME EMAIL
:result-types :auto)
=> (10)
-(clsql:select [avg [height]] :from [employee] :flatp t :field-names nil)
+(select [avg [height]] :from [employee] :flatp t :field-names nil)
=> (1.58999584d0)
(select [emplid] [last-name] :from [employee] :where [= [emplid] 1])
@@ -1442,13 +1458,21 @@ ID FORENAME SURNAME EMAIL
:flatp t)
=> (1 2 3 4)
-(clsql:select [emplid] :from [employee]
- :where [in [emplid] '(1 2 3 4)]
- :flatp t
- :order-by [emplid]
- :field-names nil)
+(select [emplid] :from [employee]
+ :where [in [emplid] '(1 2 3 4)]
+ :flatp t
+ :order-by [emplid]
+ :field-names nil)
=> (1 2 3 4)
+(select [emplid] :from [employee]
+ :order-by [emplid]
+ :limit 5
+ :offset 3
+ :field-names nil
+ :flatp t)
+=> (4 5 6 7 8)
+
(select [first-name] [last-name] :from [employee]
:field-names nil
:order-by '(([first-name] :asc) ([last-name] :desc)))