Operator class: int8

Properties

Name:	int8_ops
OID:	1981
Owner:	postgres
Default:
For type:	int8
Access method:	hash
Storage:
Comment:
Operator:	1 =(int8,int8)
Operator:
Operator:
Operator:
Function:	hashint8(bigint)
Function:	()
Function:	()
Function:	()

SQL

CREATE OPERATOR CLASS int8_ops
    DEFAULT FOR TYPE bigint USING btree AS
    OPERATOR 1 <(bigint,bigint) ,
    OPERATOR 1 <(bigint,integer) ,
    OPERATOR 1 <(bigint,smallint) ,
    OPERATOR 2 <=(bigint,smallint) ,
    OPERATOR 2 <=(bigint,bigint) ,
    OPERATOR 2 <=(bigint,integer) ,
    OPERATOR 3 =(bigint,smallint) ,
    OPERATOR 3 =(bigint,bigint) ,
    OPERATOR 3 =(bigint,integer) ,
    OPERATOR 4 >=(bigint,bigint) ,
    OPERATOR 4 >=(bigint,integer) ,
    OPERATOR 4 >=(bigint,smallint) ,
    OPERATOR 5 >(bigint,smallint) ,
    OPERATOR 5 >(bigint,bigint) ,
    OPERATOR 5 >(bigint,integer) ,
    FUNCTION 1 btint8cmp(bigint,bigint) ,
    FUNCTION 1 btint84cmp(bigint,integer) ,
    FUNCTION 1 btint82cmp(bigint,smallint);

ALTER OPERATOR CLASS pg_catalog.int8_ops USING btree OWNER TO postgres;