Properties

Name: int4_ops 
OID: 1978 
Owner: postgres 
Default:  
For type: int4 
Access method: btree 
Storage:  
Comment:  
Operator: 1 <(int4,int8) 
Operator: 2 <=(int4,int4) 
Operator: 3 =(int4,int4) 
Operator: 4 >=(int4,int4) 
Function: btint4cmp(integer, integer) 
Function: () 
Function: () 
Function: () 

SQL


CREATE OPERATOR CLASS int4_ops
    DEFAULT FOR TYPE integer USING btree AS
    OPERATOR 1 <(integer,integer) ,
    OPERATOR 1 <(integer,bigint) ,
    OPERATOR 1 <(integer,smallint) ,
    OPERATOR 2 <=(integer,smallint) ,
    OPERATOR 2 <=(integer,integer) ,
    OPERATOR 2 <=(integer,bigint) ,
    OPERATOR 3 =(integer,smallint) ,
    OPERATOR 3 =(integer,integer) ,
    OPERATOR 3 =(integer,bigint) ,
    OPERATOR 4 >=(integer,integer) ,
    OPERATOR 4 >=(integer,bigint) ,
    OPERATOR 4 >=(integer,smallint) ,
    OPERATOR 5 >(integer,smallint) ,
    OPERATOR 5 >(integer,integer) ,
    OPERATOR 5 >(integer,bigint) ,
    FUNCTION 1 btint4cmp(integer,integer) ,
    FUNCTION 1 btint48cmp(integer,bigint) ,
    FUNCTION 1 btint42cmp(integer,smallint);


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

See Also

List of operator classes