Operator class: name_pattern

Properties

Name:	name_pattern_ops
OID:	2098
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:	btname_pattern_cmp(name, name)
Function:	()
Function:	()
Function:	()

SQL

CREATE OPERATOR CLASS name_pattern_ops
    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 btname_pattern_cmp(name,name);

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