Properties

Name: _name_ops 
OID: 2768 
Owner: postgres 
Default:  
For type: _name 
Access method: gin 
Storage: name 
Comment:  
Operator: 1 &&(anyarray,anyarray) 
Operator: 2 @>(anyarray,anyarray) 
Operator: 3 <@(anyarray,anyarray) 
Operator: 4 =(anyarray,anyarray) 
Function: btnamecmp(name, name) 
Function: ginarrayextract(anyarray, internal) 
Function: ginarrayextract(anyarray, internal) 
Function: ginarrayconsistent(internal, smallint, internal) 

SQL


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


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

See Also

List of operator classes