Lines Matching refs:ORDER
48 # collate4-1.* ORDER BY.
58 # selected or not selected to implement ORDER BY clauses when
82 cksort {SELECT a FROM collate4t1 ORDER BY a}
85 cksort {SELECT a FROM collate4t1 ORDER BY a COLLATE NOCASE}
88 cksort {SELECT a FROM collate4t1 ORDER BY a COLLATE TEXT}
91 cksort {SELECT b FROM collate4t1 ORDER BY b}
94 cksort {SELECT b FROM collate4t1 ORDER BY b COLLATE TEXT}
97 cksort {SELECT b FROM collate4t1 ORDER BY b COLLATE NOCASE}
112 cksort {SELECT a FROM collate4t2 ORDER BY a}
115 cksort {SELECT a FROM collate4t2 ORDER BY a COLLATE NOCASE}
118 cksort {SELECT a FROM collate4t2 ORDER BY a COLLATE TEXT}
121 cksort {SELECT b FROM collate4t2 ORDER BY b}
124 cksort {SELECT b FROM collate4t2 ORDER BY b COLLATE TEXT}
127 cksort {SELECT b FROM collate4t2 ORDER BY b COLLATE NOCASE}
143 cksort {SELECT a FROM collate4t3 ORDER BY a}
146 cksort {SELECT a FROM collate4t3 ORDER BY a COLLATE NOCASE}
149 cksort {SELECT a FROM collate4t3 ORDER BY a COLLATE TEXT}
152 cksort {SELECT b FROM collate4t3 ORDER BY b}
155 cksort {SELECT b FROM collate4t3 ORDER BY b COLLATE TEXT}
158 cksort {SELECT b FROM collate4t3 ORDER BY b COLLATE NOCASE}
174 cksort {SELECT a FROM collate4t4 ORDER BY a}
177 cksort {SELECT a FROM collate4t4 ORDER BY a COLLATE NOCASE}
180 cksort {SELECT a FROM collate4t4 ORDER BY a COLLATE TEXT}
183 cksort {SELECT b FROM collate4t4 ORDER BY b}
186 cksort {SELECT b FROM collate4t4 ORDER BY b COLLATE TEXT}
189 cksort {SELECT b FROM collate4t4 ORDER BY b COLLATE NOCASE}
213 cksort {SELECT a FROM collate4t1 ORDER BY a}
216 cksort {SELECT a FROM collate4t1 ORDER BY a COLLATE nocase}
219 cksort {SELECT a FROM collate4t1 ORDER BY a COLLATE text}
222 cksort {SELECT a FROM collate4t1 ORDER BY a, b}
225 cksort {SELECT a FROM collate4t1 ORDER BY a, b COLLATE nocase}
228 cksort {SELECT a FROM collate4t1 ORDER BY a, b COLLATE text}
244 cksort {SELECT a FROM collate4t2 ORDER BY a}
247 cksort {SELECT a FROM collate4t2 ORDER BY a COLLATE nocase}
250 cksort {SELECT a FROM collate4t2 ORDER BY a COLLATE text}
253 cksort {SELECT a FROM collate4t2 ORDER BY a, b}
256 cksort {SELECT a FROM collate4t2 ORDER BY a, b COLLATE nocase}
259 cksort {SELECT a FROM collate4t2 ORDER BY a, b COLLATE text}
274 cksort {SELECT a FROM collate4t3 ORDER BY a}
277 cksort {SELECT a FROM collate4t3 ORDER BY a COLLATE nocase}
280 cksort {SELECT a FROM collate4t3 ORDER BY a COLLATE text}
283 cksort {SELECT a FROM collate4t3 ORDER BY a COLLATE text, b}
286 cksort {SELECT a FROM collate4t3 ORDER BY a COLLATE text, b COLLATE nocase}
289 cksort {SELECT a FROM collate4t3 ORDER BY a COLLATE text, b COLLATE text}
292 cksort {SELECT a FROM collate4t3 ORDER BY a COLLATE text DESC}
295 cksort {SELECT a FROM collate4t3 ORDER BY a COLLATE text DESC, b}
299 ORDER BY a COLLATE text DESC, b COLLATE nocase}
303 ORDER BY a COLLATE text DESC, b COLLATE nocase DESC}
687 SELECT * FROM collate4t1 ORDER BY 1;
692 SELECT * FROM collate4t1 ORDER BY oid;
697 SELECT * FROM collate4t1 ORDER BY oid||'' COLLATE TEXT;
