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