Operator class: int2

Properties

Name:	int2_ops
OID:	1976
Owner:	postgres
Default:
For type:	int2
Access method:	btree
Storage:
Comment:
Operator:	1 <(int2,int2)
Operator:	2 <=(int2,int2)
Operator:	3 =(int2,int2)
Operator:	4 >=(int2,int2)
Function:	btint2cmp(smallint, 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;