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;

See Also

List of operator classes