Properties

Name: date_ops 
OID: 435 
Owner: postgres 
Default:  
For type: date 
Access method: hash 
Storage:  
Comment:  
Operator: 1 =(date,date) 
Operator:  
Operator:  
Operator:  
Function: hashint4(integer) 
Function: () 
Function: () 
Function: () 

SQL


CREATE OPERATOR CLASS date_ops
    DEFAULT FOR TYPE date USING btree AS
    OPERATOR 1 <(date,date) ,
    OPERATOR 1 <(date,timestamp with time zone) ,
    OPERATOR 1 <(date,timestamp without time zone) ,
    OPERATOR 2 <=(date,timestamp without time zone) ,
    OPERATOR 2 <=(date,date) ,
    OPERATOR 2 <=(date,timestamp with time zone) ,
    OPERATOR 3 =(date,timestamp without time zone) ,
    OPERATOR 3 =(date,date) ,
    OPERATOR 3 =(date,timestamp with time zone) ,
    OPERATOR 4 >=(date,date) ,
    OPERATOR 4 >=(date,timestamp with time zone) ,
    OPERATOR 4 >=(date,timestamp without time zone) ,
    OPERATOR 5 >(date,timestamp without time zone) ,
    OPERATOR 5 >(date,date) ,
    OPERATOR 5 >(date,timestamp with time zone) ,
    FUNCTION 1 date_cmp(date,date) ,
    FUNCTION 1 date_cmp_timestamp(date,timestamp without time zone) ,
    FUNCTION 1 date_cmp_timestamptz(date,timestamp with time zone);


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

See Also

List of operator classes