Operator class: varchar

Properties

Name:	varchar_ops
OID:	2003
Owner:	postgres
Default:
For type:	varchar
Access method:	btree
Storage:
Comment:
Operator:	1 <(text,text)
Operator:	2 <=(text,text)
Operator:	3 =(text,text)
Operator:	4 >=(text,text)
Function:	bttextcmp(text, text)
Function:	()
Function:	()
Function:	()

SQL

CREATE OPERATOR CLASS varchar_ops
    DEFAULT FOR TYPE character varying 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 bttextcmp(text,text);

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