Operator class: timestamp

Properties

Name:	timestamp_ops
OID:	2040
Owner:	postgres
Default:
For type:	timestamp
Access method:	hash
Storage:
Comment:
Operator:	1 =(timestamp,timestamp)
Operator:
Operator:
Operator:
Function:	hashfloat8(double precision)
Function:	()
Function:	()
Function:	()

SQL

CREATE OPERATOR CLASS timestamp_ops
    DEFAULT FOR TYPE timestamp without time zone USING btree AS
    OPERATOR 1 <(timestamp without time zone,timestamp without time zone) ,
    OPERATOR 1 <(timestamp without time zone,timestamp with time zone) ,
    OPERATOR 1 <(timestamp without time zone,date) ,
    OPERATOR 2 <=(timestamp without time zone,date) ,
    OPERATOR 2 <=(timestamp without time zone,timestamp without time zone) ,
    OPERATOR 2 <=(timestamp without time zone,timestamp with time zone) ,
    OPERATOR 3 =(timestamp without time zone,date) ,
    OPERATOR 3 =(timestamp without time zone,timestamp without time zone) ,
    OPERATOR 3 =(timestamp without time zone,timestamp with time zone) ,
    OPERATOR 4 >=(timestamp without time zone,timestamp without time zone) ,
    OPERATOR 4 >=(timestamp without time zone,timestamp with time zone) ,
    OPERATOR 4 >=(timestamp without time zone,date) ,
    OPERATOR 5 >(timestamp without time zone,date) ,
    OPERATOR 5 >(timestamp without time zone,timestamp without time zone) ,
    OPERATOR 5 >(timestamp without time zone,timestamp with time zone) ,
    FUNCTION 1 timestamp_cmp(timestamp without time zone,timestamp without time zone) ,
    FUNCTION 1 timestamp_cmp_date(timestamp without time zone,date) ,
    FUNCTION 1 timestamp_cmp_timestamptz(timestamp without time zone,timestamp with time zone);

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