Operator class: float8

Properties

Name:	float8_ops
OID:	1973
Owner:	postgres
Default:
For type:	float8
Access method:	hash
Storage:
Comment:
Operator:	1 =(float8,float8)
Operator:
Operator:
Operator:
Function:	hashfloat8(double precision)
Function:	()
Function:	()
Function:	()

SQL

CREATE OPERATOR CLASS float8_ops
    DEFAULT FOR TYPE double precision USING btree AS
    OPERATOR 1 <(double precision,double precision) ,
    OPERATOR 1 <(double precision,real) ,
    OPERATOR 2 <=(double precision,double precision) ,
    OPERATOR 2 <=(double precision,real) ,
    OPERATOR 3 =(double precision,double precision) ,
    OPERATOR 3 =(double precision,real) ,
    OPERATOR 4 >=(double precision,real) ,
    OPERATOR 4 >=(double precision,double precision) ,
    OPERATOR 5 >(double precision,double precision) ,
    OPERATOR 5 >(double precision,real) ,
    FUNCTION 1 btfloat8cmp(double precision,double precision) ,
    FUNCTION 1 btfloat84cmp(double precision,real);

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