Properties

Name: varchar_ops 
OID: 2004 
Owner: postgres 
Default:  
For type: varchar 
Access method: hash 
Storage:  
Comment:  
Operator: 1 =(text,text) 
Operator:  
Operator:  
Operator:  
Function: hashtext(text) 
Function: () 
Function: () 
Function: () 

SQL


CREATE OPERATOR CLASS varchar_ops
    DEFAULT FOR TYPE character varying USING btree AS
    OPERATOR 1 <(text,text) ,
    OPERATOR 2 <=(text,text) ,
    OPERATOR 3 =(text,text) ,
    OPERATOR 4 >=(text,text) ,
    OPERATOR 5 >(text,text) ,
    FUNCTION 1 bttextcmp(text,text);


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

See Also

List of operator classes