9 ~~~~~~~~~~~~~~~~~ |
9 ~~~~~~~~~~~~~~~~~ |
10 The keywords are not case sensitive. |
10 The keywords are not case sensitive. |
11 |
11 |
12 :: |
12 :: |
13 |
13 |
14 DISTINCT, INSERT, SET, DELETE, |
14 AND, ASC, BEING, DELETE, DESC, DISTINCT, EXISTS, FALSE, GROUPBY, |
15 WHERE, AND, OR, NOT, EXISTS, |
15 HAVING, ILIKE, IN, INSERT, LIKE, LIMIT, NOT, NOW, NULL, OFFSET, |
16 IN, LIKE, UNION, WITH, BEING, |
16 OR, ORDERBY, SET, TODAY, TRUE, UNION, WHERE, WITH |
17 TRUE, FALSE, NULL, TODAY, NOW, |
|
18 LIMIT, OFFSET, |
|
19 HAVING, GROUPBY, ORDERBY, ASC, DESC |
|
20 |
|
21 |
17 |
22 Variables and Typing |
18 Variables and Typing |
23 ~~~~~~~~~~~~~~~~~~~~ |
19 ~~~~~~~~~~~~~~~~~~~~ |
24 |
20 |
25 With RQL, we do not distinguish between entities and attributes. The |
21 With RQL, we do not distinguish between entities and attributes. The |
74 |
70 |
75 Comparison operators |
71 Comparison operators |
76 ```````````````````` |
72 ```````````````````` |
77 :: |
73 :: |
78 |
74 |
79 =, <, <=, >=, >, ~=, IN, LIKE |
75 =, <, <=, >=, >, ~=, IN, LIKE, ILIKE |
80 |
76 |
81 * The operator `=` is the default operator. |
77 * The operator `=` is the default operator. |
82 |
78 |
83 * The operator `LIKE` equivalent to `~=` can be used with the |
79 * The operator `LIKE` equivalent to `~=` can be used with the |
84 special character `%` in a string to indicate that the chain |
80 special character `%` in a string to indicate that the chain |
85 must start or finish by a prefix/suffix: |
81 must start or finish by a prefix/suffix: |
86 :: |
82 :: |
87 |
83 |
88 Any X WHERE X name ~= 'Th%' |
84 Any X WHERE X name ~= 'Th%' |
89 Any X WHERE X name LIKE '%lt' |
85 Any X WHERE X name LIKE '%lt' |
|
86 |
|
87 * The operator `ILIKE` is the case insensitive version of `LIKE`. |
90 |
88 |
91 * The operator `IN` provides a list of possible values: |
89 * The operator `IN` provides a list of possible values: |
92 :: |
90 :: |
93 |
91 |
94 Any X WHERE X name IN ( 'chauvat', 'fayolle', 'di mascio', 'thenault') |
92 Any X WHERE X name IN ( 'chauvat', 'fayolle', 'di mascio', 'thenault') |