Properties

Name: bpchar_pattern_ops 
OID: 2097 
Owner: postgres 
Default:  
For type: bpchar 
Access method: btree 
Storage:  
Comment:  
Operator: 1 ~<~(bpchar,bpchar) 
Operator: 2 ~<=~(bpchar,bpchar) 
Operator: 3 ~=~(bpchar,bpchar) 
Operator: 4 ~>=~(bpchar,bpchar) 
Function: btbpchar_pattern_cmp(character, character) 
Function: () 
Function: () 
Function: () 

SQL


CREATE OPERATOR CLASS bpchar_pattern_ops
    FOR TYPE character USING btree AS
    OPERATOR 1 ~<~(character,character) ,
    OPERATOR 2 ~<=~(character,character) ,
    OPERATOR 3 ~=~(character,character) ,
    OPERATOR 4 ~>=~(character,character) ,
    OPERATOR 5 ~>~(character,character) ,
    FUNCTION 1 btbpchar_pattern_cmp(character,character);


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

See Also

List of operator classes