Properties

Name: name_ops 
OID: 1986 
Owner: postgres 
Default:  
For type: name 
Access method: btree 
Storage:  
Comment:  
Operator: 1 <(name,name) 
Operator: 2 <=(name,name) 
Operator: 3 =(name,name) 
Operator: 4 >=(name,name) 
Function: btnamecmp(name, name) 
Function: () 
Function: () 
Function: () 

SQL


CREATE OPERATOR CLASS name_ops
    DEFAULT FOR TYPE name USING btree AS
    OPERATOR 1 <(name,name) ,
    OPERATOR 2 <=(name,name) ,
    OPERATOR 3 =(name,name) ,
    OPERATOR 4 >=(name,name) ,
    OPERATOR 5 >(name,name) ,
    FUNCTION 1 btnamecmp(name,name);


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

See Also

List of operator classes