1CREATE OPERATOR === (
2        PROCEDURE = int8eq,
3        LEFTARG = bigint,
4        RIGHTARG = bigint,
5        COMMUTATOR = ===
6);
7CREATE OPERATOR !== (
8        PROCEDURE = int8ne,
9        LEFTARG = bigint,
10        RIGHTARG = bigint,
11        NEGATOR = ===,
12        COMMUTATOR = !==
13);
14DROP OPERATOR !==(bigint, bigint);
15SELECT  ctid, oprcom
16FROM    pg_catalog.pg_operator fk
17WHERE   oprcom != 0 AND
18        NOT EXISTS(SELECT 1 FROM pg_catalog.pg_operator pk WHERE pk.oid = fk.oprcom);
19 ctid | oprcom
20------+--------
21(0 rows)
22
23SELECT  ctid, oprnegate
24FROM    pg_catalog.pg_operator fk
25WHERE   oprnegate != 0 AND
26        NOT EXISTS(SELECT 1 FROM pg_catalog.pg_operator pk WHERE pk.oid = fk.oprnegate);
27 ctid | oprnegate
28------+-----------
29(0 rows)
30
31DROP OPERATOR ===(bigint, bigint);
32CREATE OPERATOR <| (
33        PROCEDURE = int8lt,
34        LEFTARG = bigint,
35        RIGHTARG = bigint
36);
37CREATE OPERATOR |> (
38        PROCEDURE = int8gt,
39        LEFTARG = bigint,
40        RIGHTARG = bigint,
41        NEGATOR = <|,
42        COMMUTATOR = <|
43);
44DROP OPERATOR |>(bigint, bigint);
45SELECT  ctid, oprcom
46FROM    pg_catalog.pg_operator fk
47WHERE   oprcom != 0 AND
48        NOT EXISTS(SELECT 1 FROM pg_catalog.pg_operator pk WHERE pk.oid = fk.oprcom);
49 ctid | oprcom
50------+--------
51(0 rows)
52
53SELECT  ctid, oprnegate
54FROM    pg_catalog.pg_operator fk
55WHERE   oprnegate != 0 AND
56        NOT EXISTS(SELECT 1 FROM pg_catalog.pg_operator pk WHERE pk.oid = fk.oprnegate);
57 ctid | oprnegate
58------+-----------
59(0 rows)
60
61DROP OPERATOR <|(bigint, bigint);
62