Operator class: _numeric

Properties

Name:	_numeric_ops
OID:	2769
Owner:	postgres
Default:
For type:	_numeric
Access method:	gin
Storage:	numeric
Comment:
Operator:	1 &&(anyarray,anyarray)
Operator:	2 @>(anyarray,anyarray)
Operator:	3 <@(anyarray,anyarray)
Operator:	4 =(anyarray,anyarray)
Function:	numeric_cmp(numeric, numeric)
Function:	ginarrayextract(anyarray, internal)
Function:	ginarrayextract(anyarray, internal)
Function:	ginarrayconsistent(internal, smallint, internal)

SQL

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

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