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
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
|
-- Test OPERATOR() syntax for qualified operator references
-- https://www.postgresql.org/docs/current/sql-syntax-lexical.html#SQL-SYNTAX-OPERATORS
-- Basic comparison operators with schema qualification
SELECT *
FROM table1
WHERE col1 OPERATOR (public.=) 'value1';
SELECT *
FROM table1
WHERE col2 OPERATOR (pg_catalog.<>) 'value2';
SELECT *
FROM table1
WHERE col3 OPERATOR (myschema.>) 100;
SELECT *
FROM table1
WHERE col4 OPERATOR (myschema.<) 100;
SELECT *
FROM table1
WHERE col5 OPERATOR (public.>=) 50;
SELECT *
FROM table1
WHERE col6 OPERATOR (public.<=) 50;
-- Arithmetic operators
SELECT col1 OPERATOR (public.+) col2 AS sum_result
FROM table1;
SELECT col1 OPERATOR (public.-) col2 AS diff_result
FROM table1;
SELECT col1 OPERATOR (public.*) col2 AS mult_result
FROM table1;
SELECT col1 OPERATOR (public./) col2 AS div_result
FROM table1;
-- String operators
SELECT str1 OPERATOR (public.||) str2 AS concatenated
FROM table1;
-- OPERATOR in HAVING clause
SELECT category, COUNT(*)
FROM products
GROUP BY category
HAVING COUNT(*) OPERATOR (public.>) 5;
-- OPERATOR in JOIN condition
SELECT t1.id, t2.name
FROM table1 AS t1
INNER JOIN table2 AS t2 ON t1.id OPERATOR (public.=) t2.table1_id;
-- OPERATOR in CASE expression
SELECT
CASE
WHEN value OPERATOR (public.>) 100 THEN 'high'
WHEN value OPERATOR (public.<=) 100 THEN 'low'
END AS category
FROM measurements;
-- Multiple schema names
SELECT *
FROM table1
WHERE col1 OPERATOR (schema1.=) val1
AND col2 OPERATOR (schema2.<>) val2;
|
