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;

See Also

List of operator classes