Operator class: timestamptz

Properties

Name:	timestamptz_ops
OID:	1999
Owner:	postgres
Default:
For type:	timestamptz
Access method:	hash
Storage:
Comment:
Operator:	1 =(timestamptz,timestamptz)
Operator:
Operator:
Operator:
Function:	hashfloat8(double precision)
Function:	()
Function:	()
Function:	()

SQL

CREATE OPERATOR CLASS timestamptz_ops
    DEFAULT FOR TYPE timestamp with time zone USING btree AS
    OPERATOR 1 <(timestamp with time zone,timestamp with time zone) ,
    OPERATOR 1 <(timestamp with time zone,timestamp without time zone) ,
    OPERATOR 1 <(timestamp with time zone,date) ,
    OPERATOR 2 <=(timestamp with time zone,date) ,
    OPERATOR 2 <=(timestamp with time zone,timestamp with time zone) ,
    OPERATOR 2 <=(timestamp with time zone,timestamp without time zone) ,
    OPERATOR 3 =(timestamp with time zone,date) ,
    OPERATOR 3 =(timestamp with time zone,timestamp with time zone) ,
    OPERATOR 3 =(timestamp with time zone,timestamp without time zone) ,
    OPERATOR 4 >=(timestamp with time zone,timestamp with time zone) ,
    OPERATOR 4 >=(timestamp with time zone,timestamp without time zone) ,
    OPERATOR 4 >=(timestamp with time zone,date) ,
    OPERATOR 5 >(timestamp with time zone,date) ,
    OPERATOR 5 >(timestamp with time zone,timestamp with time zone) ,
    OPERATOR 5 >(timestamp with time zone,timestamp without time zone) ,
    FUNCTION 1 timestamptz_cmp(timestamp with time zone,timestamp with time zone) ,
    FUNCTION 1 timestamptz_cmp_date(timestamp with time zone,date) ,
    FUNCTION 1 timestamptz_cmp_timestamp(timestamp with time zone,timestamp without time zone);

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