Operator class: float8

Properties

Name:	float8_ops
OID:	1972
Owner:	postgres
Default:
For type:	float8
Access method:	btree
Storage:
Comment:
Operator:	1 <(float8,float8)
Operator:	2 <=(float8,float8)
Operator:	3 =(float8,float8)
Operator:	4 >=(float8,float8)
Function:	btfloat8cmp(double precision, 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;