Operator class: text_pattern

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;