Operator class: timestamp

Properties

Name:	timestamp_ops
OID:	2039
Owner:	postgres
Default:
For type:	timestamp
Access method:	btree
Storage:
Comment:
Operator:	1 <(timestamp,timestamp)
Operator:	2 <=(timestamp,timestamp)
Operator:	3 =(timestamp,timestamp)
Operator:	4 >=(timestamp,timestamp)
Function:	timestamp_cmp(timestamp without time zone, timestamp without time zone)
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;