Properties

Name: text_pattern_ops 
OID: 2229 
Owner: postgres 
Default:  
For type: text 
Access method: hash 
Storage:  
Comment:  
Operator: 1 ~=~(text,text) 
Operator:  
Operator:  
Operator:  
Function: hashvarlena(internal) 
Function: () 
Function: () 
Function: () 

SQL


CREATE OPERATOR CLASS text_pattern_ops
    FOR TYPE text 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 bttext_pattern_cmp(text,text);


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

See Also

List of operator classes