Operator class: _text

Properties

Name:	_text_ops
OID:	2746
Owner:	postgres
Default:
For type:	_text
Access method:	gin
Storage:	text
Comment:
Operator:	1 &&(anyarray,anyarray)
Operator:	2 @>(anyarray,anyarray)
Operator:	3 <@(anyarray,anyarray)
Operator:	4 =(anyarray,anyarray)
Function:	bttextcmp(text, text)
Function:	ginarrayextract(anyarray, internal)
Function:	ginarrayextract(anyarray, internal)
Function:	ginarrayconsistent(internal, smallint, internal)

SQL

CREATE OPERATOR CLASS _text_ops
    DEFAULT FOR TYPE text[] USING gin AS
    STORAGE text ,
    OPERATOR 1 &&(anyarray,anyarray) ,
    OPERATOR 2 @>(anyarray,anyarray) ,
    OPERATOR 3 <@(anyarray,anyarray) RECHECK ,
    OPERATOR 4 =(anyarray,anyarray) RECHECK ,
    FUNCTION 1 bttextcmp(text,text) ,
    FUNCTION 2 ginarrayextract(anyarray,internal) ,
    FUNCTION 3 ginarrayextract(anyarray,internal) ,
    FUNCTION 4 ginarrayconsistent(internal,smallint,internal);

ALTER OPERATOR CLASS pg_catalog._text_ops USING gin OWNER TO postgres;