Operator class: name

Properties

Name:	name_ops
OID:	1986
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:	btnamecmp(name, name)
Function:	()
Function:	()
Function:	()

SQL

CREATE OPERATOR CLASS name_ops
    DEFAULT 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 btnamecmp(name,name);

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