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