Lines Matching refs:ORDER
31 # is similar to the built-in TEXT collation type except the order of
98 SELECT a FROM collate2t1 WHERE a > 'aa' ORDER BY 1;
103 SELECT a FROM collate2t1 WHERE a COLLATE binary > 'aa' ORDER BY 1;
108 SELECT a FROM collate2t1 WHERE b COLLATE binary > 'aa' ORDER BY 1;
113 SELECT a FROM collate2t1 WHERE c COLLATE binary > 'aa' ORDER BY 1;
118 SELECT b FROM collate2t1 WHERE b > 'aa' ORDER BY 1, oid;
124 ORDER BY 1, oid;
130 ORDER BY 1, oid;
136 ORDER BY 1, oid;
141 SELECT b FROM collate2t1 WHERE b > 'aa' ORDER BY +b;
146 SELECT b FROM collate2t1 WHERE a COLLATE nocase > 'aa' ORDER BY +b;
151 SELECT b FROM collate2t1 WHERE b COLLATE nocase > 'aa' ORDER BY +b;
156 SELECT b FROM collate2t1 WHERE c COLLATE nocase > 'aa' ORDER BY +b;
161 SELECT c FROM collate2t1 WHERE c > 'aa' ORDER BY 1;
167 ORDER BY 1;
173 ORDER BY 1;
179 ORDER BY 1;
184 SELECT a FROM collate2t1 WHERE a < 'aa' ORDER BY 1;
189 SELECT b FROM collate2t1 WHERE b < 'aa' ORDER BY 1, oid;
194 SELECT b FROM collate2t1 WHERE b < 'aa' ORDER BY +b;
199 SELECT c FROM collate2t1 WHERE c < 'aa' ORDER BY 1;
209 SELECT b FROM collate2t1 WHERE b = 'aa' ORDER BY oid;
219 SELECT a FROM collate2t1 WHERE a >= 'aa' ORDER BY 1;
224 SELECT b FROM collate2t1 WHERE b >= 'aa' ORDER BY 1, oid;
229 SELECT c FROM collate2t1 WHERE c >= 'aa' ORDER BY 1;
234 SELECT a FROM collate2t1 WHERE a <= 'aa' ORDER BY 1;
239 SELECT b FROM collate2t1 WHERE b <= 'aa' ORDER BY 1, oid;
244 SELECT c FROM collate2t1 WHERE c <= 'aa' ORDER BY 1;
249 SELECT a FROM collate2t1 WHERE a BETWEEN 'Aa' AND 'Bb' ORDER BY 1;
254 SELECT b FROM collate2t1 WHERE b BETWEEN 'Aa' AND 'Bb' ORDER BY 1, oid;
259 SELECT b FROM collate2t1 WHERE b BETWEEN 'Aa' AND 'Bb' ORDER BY +b;
264 SELECT c FROM collate2t1 WHERE c BETWEEN 'Aa' AND 'Bb' ORDER BY 1;
271 ORDER BY 1, oid;
278 ORDER BY 1, oid;
285 ORDER BY 1, oid;
292 SELECT a FROM collate2t1 WHERE a IN ('aa', 'bb') ORDER BY 1, oid;
297 SELECT b FROM collate2t1 WHERE b IN ('aa', 'bb') ORDER BY 1, oid;
302 SELECT c FROM collate2t1 WHERE c IN ('aa', 'bb') ORDER BY 1, oid;
327 SELECT a FROM collate2t1 WHERE NOT a > 'aa' ORDER BY 1;
332 SELECT b FROM collate2t1 WHERE NOT b > 'aa' ORDER BY 1, oid;
337 SELECT c FROM collate2t1 WHERE NOT c > 'aa' ORDER BY 1;
342 SELECT a FROM collate2t1 WHERE NOT a < 'aa' ORDER BY 1;
347 SELECT b FROM collate2t1 WHERE NOT b < 'aa' ORDER BY 1, oid;
352 SELECT c FROM collate2t1 WHERE NOT c < 'aa' ORDER BY 1;
372 SELECT a FROM collate2t1 WHERE NOT a >= 'aa' ORDER BY 1;
377 SELECT b FROM collate2t1 WHERE NOT b >= 'aa' ORDER BY 1, oid;
382 SELECT c FROM collate2t1 WHERE NOT c >= 'aa' ORDER BY 1;
387 SELECT a FROM collate2t1 WHERE NOT a <= 'aa' ORDER BY 1;
392 SELECT b FROM collate2t1 WHERE NOT b <= 'aa' ORDER BY 1, oid;
397 SELECT c FROM collate2t1 WHERE NOT c <= 'aa' ORDER BY 1;
402 SELECT a FROM collate2t1 WHERE a NOT BETWEEN 'Aa' AND 'Bb' ORDER BY 1;
407 SELECT b FROM collate2t1 WHERE b NOT BETWEEN 'Aa' AND 'Bb' ORDER BY 1, oid;
412 SELECT c FROM collate2t1 WHERE c NOT BETWEEN 'Aa' AND 'Bb' ORDER BY 1;
685 SELECT collate2t2.b FROM collate2t1 LEFT OUTER JOIN collate2t2 USING (b) order by collate2t1.oid;
