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