4 SELECT "x"."y" FROM "a"
5 SELECT "x" FROM "a"."b"
7 SELECT "y" FROM "foo"()
8 syntax error: SELECT * FROM (SELECT * FROM foo);
9 SELECT "a" AS "t" FROM "x"
10 SELECT "x" FROM "a" AS "b"
11 SELECT "a" AS "tttttttttttttttttttttttttttttttttttttttttttttttttttttttt" ,"b" AS "uuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu" FROM "zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz"
12 syntax error: SELECT ;
13 SELECT "*" FROM "t" FOR UPDATE
14 SELECT "*" FROM "t" FOR SHARED
15 SELECT DISTINCT "*" FROM "t"
16 SELECT DISTINCT ON ("x" ) "x" FROM "t"
17 SELECT DISTINCT ON ("foo"("x") ) "x" FROM "t"
19 SELECT "x" FROM "t" WHERE ("x">3 )
20 SELECT "count"(*) FROM "t" GROUP BY "x" HAVING ("x">111 )
21 SELECT "count"(*) FROM "t" GROUP BY "x" HAVING ("x">111 ) ORDER BY "y"
22 SELECT "count"(*) FROM "t" GROUP BY "x" HAVING ("x">111 ) ORDER BY "y" DESC
23 SELECT "count"(*) FROM "t" GROUP BY "x" HAVING ("x">111 ) ORDER BY "y"
24 SELECT "x" FROM "t" LIMIT ALL
25 SELECT "x" FROM "t" LIMIT 1
26 SELECT "*" FROM "t" OFFSET 1
27 SELECT "*" FROM "t" OFFSET 1 LIMIT 2
28 SELECT "*" FROM "t" OFFSET 1 LIMIT 2
29 SELECT "*" FROM "t" LEFT OUTER JOIN "t1" ON ("x"="y" )
30 SELECT "*" FROM "t" RIGHT OUTER JOIN "t1" ON ("x"="y" )
31 SELECT "*" FROM "t" FULL OUTER JOIN "t1" ON ("x"="y" )
32 SELECT "*" FROM "t" LEFT OUTER JOIN "t1" USING("x")
33 SELECT "*" FROM "t" RIGHT OUTER JOIN "t1" USING("x")
34 SELECT "*" FROM "t" FULL OUTER JOIN "t1" USING("x")
35 SELECT "*" FROM "t" JOIN "t1" ON "x"
36 SELECT "*" FROM "t" NATURAL LEFT OUTER JOIN "t1"
37 SELECT "*" FROM "t" NATURAL RIGHT OUTER JOIN "t1"
38 SELECT "*" FROM "t" NATURAL FULL OUTER JOIN "t1"
39 SELECT "*" FROM "t" WHERE "a" IS NULL
40 SELECT "*" FROM "t" WHERE "a" IS NOT NULL
41 SELECT "*" FROM "t" WHERE ("a"~~'abc' )
42 SELECT "*" FROM "t" WHERE ("a"!~~'abc' )
43 SELECT "*" FROM "t" WHERE ( ("a">=1 ) AND ("a"<=4 ))
44 SELECT "*" FROM "t" WHERE "a" IN (1,2,3,4)
45 SELECT "*" FROM "t" WHERE "a" NOT IN (1,2,3,4)
46 SELECT "*" FROM "t" WHERE EXISTS ( SELECT "*" FROM "tt")
47 SELECT "*" FROM "t" WHERE (NOT EXISTS ( SELECT "*" FROM "tt"))
48 ( SELECT "*" FROM "t1") UNION ( SELECT "*" FROM "t2")
49 ( SELECT "*" FROM "t1") UNION ALL ( SELECT "*" FROM "t2")
50 ( SELECT "*" FROM "t1") INTERSECT ( SELECT "*" FROM "t2")
51 ( SELECT "*" FROM "t1") INTERSECT ALL ( SELECT "*" FROM "t2")
52 ( SELECT "*" FROM "t1") EXCEPT ( SELECT "*" FROM "t2")
53 ( SELECT "*" FROM "t1") EXCEPT ALL ( SELECT "*" FROM "t2")
54 CREATE TABLE "x" AS SELECT "*" FROM "t"
55 SELECT "*" FROM "t1" WHERE "i"<> ALL ( SELECT "i" FROM "t2")
56 ( SELECT "*" FROM "t1") UNION ALL ( SELECT "*" FROM "t2") ORDER BY "a"
57 ( SELECT "*" FROM "t1") UNION ALL ( SELECT "*" FROM "t2" ORDER BY "a")
58 SELECT "max"("i")::"int4" FROM "test"
59 SELECT "max"("i")::"int4" FROM "test" WHERE ("a"='aaa''bbb\\ccc' )
60 SELECT "max"("i")::"int4" FROM "test" WHERE ("a"='aaa''bbb\\ccc' )
61 SELECT "*" FROM "t" WHERE 1=ANY("arr")
62 SELECT "*" FROM "t" WHERE 1=ALL("arr")
63 SELECT "*" FROM "t" WHERE 1 IS OF ("int4")
64 SELECT "*" FROM "t" WHERE 1 IS OF ("int4")
65 SELECT "*" FROM "t" WHERE "a" IN ('a','b',1)
66 SELECT "*" FROM "t" WHERE "a" NOT IN ('a','b',1)
67 SELECT "*" FROM "t" WHERE "a" IS DOCUMENT
68 SELECT "*" FROM "t" WHERE (NOT "a" IS DOCUMENT)
69 SELECT XMLCONCAT ("a","b")
70 SELECT XMLELEMENT (NAME "a")
71 SELECT XMLELEMENT (NAME "a","b","c")
72 SELECT XMLFOREST ("a")
73 SELECT XMLPARSE (DOCUMENT 1)
74 SELECT XMLPARSE (DOCUMENT 1 PRESERVE WHITESPACE)
75 SELECT "day" '1900-1-1'
76 SELECT "interval" '1 year'
77 SELECT "interval" '1 year' YEAR
78 SELECT "interval" '1 year' MONTH
79 SELECT "interval" '1 year' DAY
80 SELECT "interval" '1 year' HOUR
81 SELECT "interval" '1 year' MINUTE
82 SELECT "interval" '1 year' SECOND
83 SELECT "interval" '1 year' YEAR TO MONTH
84 SELECT "interval" '1 year' DAY TO HOUR
85 SELECT "interval" '1 year' DAY TO MINUTE
86 SELECT "interval" '1 year' DAY TO SECOND
87 SELECT "interval" '1 year' HOUR TO MINUTE
88 SELECT "interval" '1 year' HOUR TO SECOND