# HG changeset patch
# User Adrien Di Mascio <Adrien.DiMascio@logilab.fr>
# Date 1231932995 -3600
# Node ID 295f3cd70915df82bf2b16104c5560e8284af776
# Parent  867f933eeb89e8344882d7c9d6a44669ca4d316a
[documentation] add some more rql documentation

diff -r 867f933eeb89 -r 295f3cd70915 doc/book/en/C040-rql.en.txt
--- a/doc/book/en/C040-rql.en.txt	Wed Jan 14 11:42:52 2009 +0100
+++ b/doc/book/en/C040-rql.en.txt	Wed Jan 14 12:36:35 2009 +0100
@@ -108,22 +108,22 @@
 - *Looking for people working for eurocopter interested in training*
    ::
 
-        Person P WHERE
-        P work_for P, S name 'Eurocopter'
+        Any P WHERE
+        P is Person, P work_for P, S name 'Eurocopter'
         P interested_by T, T name 'training'
 
 - *Search note less than 10 days old written by jphc or ocy*
    ::
 
-        Note N WHERE
-        N written_on D, D day> (today -10),
+        Any N WHERE
+        N is Note, N written_on D, D day> (today -10),
         N written_by P, P name 'jphc' or P name 'ocy'
 
 - *Looking for people interested in training or living in Paris*
    ::
 
-        Person P WHERE
-        (P interested_by T, T name 'training') or
+        Any P WHERE
+        P is Person, (P interested_by T, T name 'training') OR
         (P city 'Paris')
 
 - *The name and surname of all people*
@@ -158,7 +158,7 @@
 - *Insert a new person named 'foo'*
    ::
 
-        INSERT Person X: X name 'widget'
+        INSERT Person X: X name 'foo'
 
 - *Insert a new person named 'foo', another called 'nice' and a 'friend' relation
   between them*
@@ -211,6 +211,56 @@
         DELETE X friend Y WHERE X is Person, X name 'foo'
 
 
+Undocumented (yet) type of queries
+----------------------------------
+
+**Limit / offset**
+::
+    
+    Any P ORDERBY N LIMIT 5 OFFSET 10 WHERE P is Person, P firstname N
+
+**Function calls**
+::
+    
+    Any UPPER(N) WHERE P firstname N
+
+**Exists**
+::
+    
+    Any X ORDERBY PN,N
+    WHERE X num N, X version_of P, P name PN, 
+          EXISTS(X in_state S, S name IN ("dev", "ready"))
+          OR EXISTS(T tags X, T name "priority")
+
+**Left outer join**
+::
+
+    Any T,P,V WHERE T is Ticket, T concerns P, T done_in V?
+    
+    
+**Having**
+::
+    
+    Any X GROUPBY X WHERE X knows Y HAVING COUNT(Y) > 10
+
+**Simple union**
+::
+
+    (Any X WHERE X is Person) UNION (Any X WHERE X is Company)
+    
+**Complex union**
+::
+
+     DISTINCT Any W, REF
+        WITH W, REF BEING 
+            (
+	      (Any W, REF WHERE W is Workcase, W ref REF, 
+                                 W concerned_by D, D name "Logilab")
+               UNION 
+              (Any W, REF WHERE W is Workcase, W ref REF, '
+                                W split_into WP, WP name "WP1")
+            )
+
 
 Language definition
 ===================
@@ -222,10 +272,11 @@
 ::
 
      DISTINCT, INSERT, SET, DELETE,
-     WHERE, AND, OR, NOT
-     IN, LIKE,
-     TRUE, FALSE, NULL, TODAY, NOW
-     GROUPBY, ORDERBY, ASC, DESC
+     WHERE, AND, OR, NOT, EXISTS,
+     IN, LIKE, UNION, WITH, BEING,
+     TRUE, FALSE, NULL, TODAY, NOW,
+     LIMIT, OFFSET,
+     HAVING, GROUPBY, ORDERBY, ASC, DESC
 
 
 Variables and Typing