Operator class: int2

Properties

Name:	int2_ops
OID:	1977
Owner:	postgres
Default:
For type:	int2
Access method:	hash
Storage:
Comment:
Operator:	1 =(int2,int2)
Operator:
Operator:
Operator:
Function:	hashint2(smallint)
Function:	()
Function:	()
Function:	()

SQL

CREATE OPERATOR CLASS int2_ops
    DEFAULT FOR TYPE smallint USING btree AS
    OPERATOR 1 <(smallint,smallint) ,
    OPERATOR 1 <(smallint,bigint) ,
    OPERATOR 1 <(smallint,integer) ,
    OPERATOR 2 <=(smallint,integer) ,
    OPERATOR 2 <=(smallint,smallint) ,
    OPERATOR 2 <=(smallint,bigint) ,
    OPERATOR 3 =(smallint,integer) ,
    OPERATOR 3 =(smallint,smallint) ,
    OPERATOR 3 =(smallint,bigint) ,
    OPERATOR 4 >=(smallint,smallint) ,
    OPERATOR 4 >=(smallint,bigint) ,
    OPERATOR 4 >=(smallint,integer) ,
    OPERATOR 5 >(smallint,integer) ,
    OPERATOR 5 >(smallint,smallint) ,
    OPERATOR 5 >(smallint,bigint) ,
    FUNCTION 1 btint2cmp(smallint,smallint) ,
    FUNCTION 1 btint24cmp(smallint,integer) ,
    FUNCTION 1 btint28cmp(smallint,bigint);

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