Properties

Name: numeric_ops 
OID: 1988 
Owner: postgres 
Default:  
For type: numeric 
Access method: btree 
Storage:  
Comment:  
Operator: 1 <(numeric,numeric) 
Operator: 2 <=(numeric,numeric) 
Operator: 3 =(numeric,numeric) 
Operator: 4 >=(numeric,numeric) 
Function: numeric_cmp(numeric, numeric) 
Function: () 
Function: () 
Function: () 

SQL


CREATE OPERATOR CLASS numeric_ops
    DEFAULT FOR TYPE numeric USING btree AS
    OPERATOR 1 <(numeric,numeric) ,
    OPERATOR 2 <=(numeric,numeric) ,
    OPERATOR 3 =(numeric,numeric) ,
    OPERATOR 4 >=(numeric,numeric) ,
    OPERATOR 5 >(numeric,numeric) ,
    FUNCTION 1 numeric_cmp(numeric,numeric);


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

See Also

List of operator classes