1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
|
SELECT 1 + (2 * 3) >= 4 + 6+13 as val;
SELECT 1 + ~(~2 * 3) >= 4 + ~6+13 as val;
SELECT -1;
SELECT -1 + 5;
SELECT ~1;
SELECT -1 + ~5;
SELECT 4 & ~8 | 16;
SELECT 8 + ~(3);
SELECT 8 | ~ ~ ~4;
SELECT 1 * -(5);
SELECT 1 * -5;
SELECT 1 * - - - 5;
SELECT 1 * - - - (5);
SELECT 1 * + + (5);
SELECT 1 * - - - func(5);
SELECT 1 * ~ ~ ~ func(5);
SELECT 1 * +(5);
SELECT 1 * +5;
SELECT 1 * + + 5;
SELECT FALSE AND NOT (TRUE);
SELECT FALSE AND NOT NOT NOT (TRUE); -- parses middle NOT as column ref
SELECT FALSE AND NOT (TRUE);
SELECT FALSE AND NOT func(5);
SELECT 'abc' LIKE - - 5; -- PG can parse this ok, and then fail due to data type mismatch
SELECT 'abc' LIKE ~ ~ 5; -- PG can parse this ok, and then fail due to data type mismatch
|
