anyarray--1.0.sql

/* contrib/anyarray/anyarray--1.0.sql */

-- complain if script is sourced in psql, rather than via CREATE EXTENSION
\echo Use "CREATE EXTENSION anyarray" to load this file. \quit

--
-- Create the user-defined type for the 1-D integer arrays (_int4)
--

CREATE FUNCTION anyset(anyelement)
	RETURNS anyarray
	AS 'MODULE_PATHNAME', 'aa_set'
	LANGUAGE C STRICT IMMUTABLE;

CREATE FUNCTION icount(anyarray)
	RETURNS int4
	AS 'MODULE_PATHNAME', 'aa_icount'
	LANGUAGE C STRICT IMMUTABLE;

CREATE OPERATOR # (
	RIGHTARG = anyarray,
	PROCEDURE = icount
);

CREATE FUNCTION sort(anyarray)
	RETURNS anyarray
	AS 'MODULE_PATHNAME', 'aa_sort'
	LANGUAGE C STRICT IMMUTABLE;

CREATE FUNCTION sort(anyarray, text)
	RETURNS anyarray
	AS 'MODULE_PATHNAME', 'aa_sort'
	LANGUAGE C STRICT IMMUTABLE;

CREATE FUNCTION sort_asc(anyarray)
	RETURNS anyarray
	AS 'MODULE_PATHNAME', 'aa_sort_asc'
	LANGUAGE C STRICT IMMUTABLE;

CREATE FUNCTION sort_desc(anyarray)
	RETURNS anyarray
	AS 'MODULE_PATHNAME', 'aa_sort_desc'
	LANGUAGE C STRICT IMMUTABLE;

CREATE FUNCTION uniq(anyarray)
	RETURNS anyarray
	AS 'MODULE_PATHNAME', 'aa_uniq'
	LANGUAGE C STRICT IMMUTABLE;

CREATE FUNCTION uniq_d(anyarray)
	RETURNS anyarray
	AS 'MODULE_PATHNAME', 'aa_uniqd'
	LANGUAGE C STRICT IMMUTABLE;

CREATE FUNCTION idx(anyarray, anyelement)
	RETURNS int4
	AS 'MODULE_PATHNAME', 'aa_idx'
	LANGUAGE C STRICT IMMUTABLE;

CREATE FUNCTION subarray(anyarray, int4)
	RETURNS anyarray
	AS 'MODULE_PATHNAME', 'aa_subarray'
	LANGUAGE C STRICT IMMUTABLE;

CREATE FUNCTION subarray(anyarray, int4, int4)
	RETURNS anyarray
	AS 'MODULE_PATHNAME', 'aa_subarray'
	LANGUAGE C STRICT IMMUTABLE;

CREATE OPERATOR + (
	LEFTARG = anycompatiblearray,
	RIGHTARG = anycompatible,
	PROCEDURE = array_append
);

CREATE OPERATOR + (
	LEFTARG = anycompatiblearray,
	RIGHTARG = anycompatiblearray,
	PROCEDURE = array_cat
);

CREATE OPERATOR - (
	LEFTARG = anycompatiblearray,
	RIGHTARG = anycompatible,
	PROCEDURE = array_remove
);

CREATE FUNCTION subtract_array(anyarray, anyarray)
	RETURNS anyarray
	AS 'MODULE_PATHNAME', 'aa_subtract_array'
	LANGUAGE C STRICT IMMUTABLE;

CREATE OPERATOR - (
	LEFTARG = anyarray,
	RIGHTARG = anyarray,
	PROCEDURE = subtract_array
);

CREATE FUNCTION union_elem(anyarray, anyelement)
	RETURNS anyarray
	AS 'MODULE_PATHNAME', 'aa_union_elem'
	LANGUAGE C STRICT IMMUTABLE;

CREATE OPERATOR | (
	LEFTARG = anyarray,
	RIGHTARG = anyelement,
	PROCEDURE = union_elem
);

CREATE FUNCTION union_array(anyarray, anyarray)
	RETURNS anyarray
	AS 'MODULE_PATHNAME', 'aa_union_array'
	LANGUAGE C STRICT IMMUTABLE;

CREATE OPERATOR | (
	LEFTARG = anyarray,
	RIGHTARG = anyarray,
	PROCEDURE = union_array
);

CREATE FUNCTION intersect_array(anyarray, anyarray)
	RETURNS anyarray
	AS 'MODULE_PATHNAME', 'aa_intersect_array'
	LANGUAGE C STRICT IMMUTABLE;

CREATE OPERATOR & (
	LEFTARG = anyarray,
	RIGHTARG = anyarray,
	PROCEDURE = intersect_array
);

CREATE FUNCTION similarity(anyarray, anyarray)
	RETURNS float4
	AS 'MODULE_PATHNAME', 'aa_similarity'
	LANGUAGE C STRICT IMMUTABLE;

CREATE FUNCTION similarity_op(anyarray, anyarray)
	RETURNS bool
	AS 'MODULE_PATHNAME', 'aa_similarity_op'
	LANGUAGE C STRICT IMMUTABLE;

CREATE OPERATOR % (
	LEFTARG = anyarray,
	RIGHTARG = anyarray,
	PROCEDURE = similarity_op,
	COMMUTATOR = '%',
	RESTRICT = contsel,
	JOIN = contjoinsel
);

CREATE FUNCTION distance(anyarray, anyarray)
	RETURNS float4
	AS 'MODULE_PATHNAME', 'aa_distance'
	LANGUAGE C STRICT IMMUTABLE;

CREATE OPERATOR <-> (
	LEFTARG = anyarray,
	RIGHTARG = anyarray,
	PROCEDURE = distance
);

--GiST interface

CREATE FUNCTION ganyarrayin(cstring)
	RETURNS ganyarray
	AS 'MODULE_PATHNAME'
	LANGUAGE C STRICT IMMUTABLE;

CREATE FUNCTION ganyarrayout(ganyarray)
	RETURNS cstring
	AS 'MODULE_PATHNAME'
	LANGUAGE C STRICT IMMUTABLE;

CREATE TYPE ganyarray (
	INTERNALLENGTH = -1,
	INPUT = ganyarrayin,
	OUTPUT = ganyarrayout
);

CREATE FUNCTION ganyarray_consistent(internal,internal,int,oid,internal)
	RETURNS bool
	AS 'MODULE_PATHNAME'
	LANGUAGE C IMMUTABLE STRICT;

CREATE FUNCTION ganyarray_compress(internal)
	RETURNS internal
	AS 'MODULE_PATHNAME'
	LANGUAGE C IMMUTABLE STRICT;

CREATE FUNCTION ganyarray_decompress(internal)
	RETURNS internal
	AS 'MODULE_PATHNAME'
	LANGUAGE C IMMUTABLE STRICT;

CREATE FUNCTION ganyarray_penalty(internal,internal,internal)
	RETURNS internal
	AS 'MODULE_PATHNAME'
	LANGUAGE C IMMUTABLE STRICT;

CREATE FUNCTION ganyarray_picksplit(internal, internal)
	RETURNS internal
	AS 'MODULE_PATHNAME'
	LANGUAGE C IMMUTABLE STRICT;

CREATE FUNCTION ganyarray_union(bytea, internal)
	RETURNS _int4
	AS 'MODULE_PATHNAME'
	LANGUAGE C IMMUTABLE STRICT;

CREATE FUNCTION ganyarray_same(ganyarray, ganyarray, internal)
	RETURNS internal
	AS 'MODULE_PATHNAME'
	LANGUAGE C IMMUTABLE STRICT;


--create the operator classes for gist

CREATE OPERATOR CLASS _int2_aa_ops
FOR TYPE _int2 USING gist
AS
	OPERATOR	3	&&	(anyarray, anyarray),
	OPERATOR	6	=	(anyarray, anyarray),
	OPERATOR	7	@>	(anyarray, anyarray),
	OPERATOR	8	<@	(anyarray, anyarray),
	OPERATOR	16	%	(anyarray, anyarray),
	FUNCTION	1	ganyarray_consistent(internal,internal,int,oid,internal),
	FUNCTION	2	ganyarray_union (bytea, internal),
	FUNCTION	3	ganyarray_compress (internal),
	FUNCTION	4	ganyarray_decompress (internal),
	FUNCTION	5	ganyarray_penalty (internal, internal, internal),
	FUNCTION	6	ganyarray_picksplit (internal, internal),
	FUNCTION	7	ganyarray_same (ganyarray, ganyarray, internal),
STORAGE         ganyarray;

CREATE OPERATOR CLASS _int4_aa_ops
FOR TYPE _int4 USING gist
AS
	OPERATOR	3	&&	(anyarray, anyarray),
	OPERATOR	6	=	(anyarray, anyarray),
	OPERATOR	7	@>	(anyarray, anyarray),
	OPERATOR	8	<@	(anyarray, anyarray),
	OPERATOR	16	%	(anyarray, anyarray),
	FUNCTION	1	ganyarray_consistent(internal,internal,int,oid,internal),
	FUNCTION	2	ganyarray_union (bytea, internal),
	FUNCTION	3	ganyarray_compress (internal),
	FUNCTION	4	ganyarray_decompress (internal),
	FUNCTION	5	ganyarray_penalty (internal, internal, internal),
	FUNCTION	6	ganyarray_picksplit (internal, internal),
	FUNCTION	7	ganyarray_same (ganyarray, ganyarray, internal),
STORAGE         ganyarray;

CREATE OPERATOR CLASS _int8_aa_ops
FOR TYPE _int8 USING gist
AS
	OPERATOR	3	&&	(anyarray, anyarray),
	OPERATOR	6	=	(anyarray, anyarray),
	OPERATOR	7	@>	(anyarray, anyarray),
	OPERATOR	8	<@	(anyarray, anyarray),
	OPERATOR	16	%	(anyarray, anyarray),
	FUNCTION	1	ganyarray_consistent(internal,internal,int,oid,internal),
	FUNCTION	2	ganyarray_union (bytea, internal),
	FUNCTION	3	ganyarray_compress (internal),
	FUNCTION	4	ganyarray_decompress (internal),
	FUNCTION	5	ganyarray_penalty (internal, internal, internal),
	FUNCTION	6	ganyarray_picksplit (internal, internal),
	FUNCTION	7	ganyarray_same (ganyarray, ganyarray, internal),
STORAGE         ganyarray;

CREATE OPERATOR CLASS _float4_aa_ops
FOR TYPE _float4 USING gist
AS
	OPERATOR	3	&&	(anyarray, anyarray),
	OPERATOR	6	=	(anyarray, anyarray),
	OPERATOR	7	@>	(anyarray, anyarray),
	OPERATOR	8	<@	(anyarray, anyarray),
	OPERATOR	16	%	(anyarray, anyarray),
	FUNCTION	1	ganyarray_consistent(internal,internal,int,oid,internal),
	FUNCTION	2	ganyarray_union (bytea, internal),
	FUNCTION	3	ganyarray_compress (internal),
	FUNCTION	4	ganyarray_decompress (internal),
	FUNCTION	5	ganyarray_penalty (internal, internal, internal),
	FUNCTION	6	ganyarray_picksplit (internal, internal),
	FUNCTION	7	ganyarray_same (ganyarray, ganyarray, internal),
STORAGE         ganyarray;

CREATE OPERATOR CLASS _float8_aa_ops
FOR TYPE _float8 USING gist
AS
	OPERATOR	3	&&	(anyarray, anyarray),
	OPERATOR	6	=	(anyarray, anyarray),
	OPERATOR	7	@>	(anyarray, anyarray),
	OPERATOR	8	<@	(anyarray, anyarray),
	OPERATOR	16	%	(anyarray, anyarray),
	FUNCTION	1	ganyarray_consistent(internal,internal,int,oid,internal),
	FUNCTION	2	ganyarray_union (bytea, internal),
	FUNCTION	3	ganyarray_compress (internal),
	FUNCTION	4	ganyarray_decompress (internal),
	FUNCTION	5	ganyarray_penalty (internal, internal, internal),
	FUNCTION	6	ganyarray_picksplit (internal, internal),
	FUNCTION	7	ganyarray_same (ganyarray, ganyarray, internal),
STORAGE         ganyarray;

CREATE OPERATOR CLASS _oid_aa_ops
FOR TYPE _oid USING gist
AS
	OPERATOR	3	&&	(anyarray, anyarray),
	OPERATOR	6	=	(anyarray, anyarray),
	OPERATOR	7	@>	(anyarray, anyarray),
	OPERATOR	8	<@	(anyarray, anyarray),
	OPERATOR	16	%	(anyarray, anyarray),
	FUNCTION	1	ganyarray_consistent(internal,internal,int,oid,internal),
	FUNCTION	2	ganyarray_union (bytea, internal),
	FUNCTION	3	ganyarray_compress (internal),
	FUNCTION	4	ganyarray_decompress (internal),
	FUNCTION	5	ganyarray_penalty (internal, internal, internal),
	FUNCTION	6	ganyarray_picksplit (internal, internal),
	FUNCTION	7	ganyarray_same (ganyarray, ganyarray, internal),
STORAGE         ganyarray;

CREATE OPERATOR CLASS _timestamp_aa_ops
FOR TYPE _timestamp USING gist
AS
	OPERATOR	3	&&	(anyarray, anyarray),
	OPERATOR	6	=	(anyarray, anyarray),
	OPERATOR	7	@>	(anyarray, anyarray),
	OPERATOR	8	<@	(anyarray, anyarray),
	OPERATOR	16	%	(anyarray, anyarray),
	FUNCTION	1	ganyarray_consistent(internal,internal,int,oid,internal),
	FUNCTION	2	ganyarray_union (bytea, internal),
	FUNCTION	3	ganyarray_compress (internal),
	FUNCTION	4	ganyarray_decompress (internal),
	FUNCTION	5	ganyarray_penalty (internal, internal, internal),
	FUNCTION	6	ganyarray_picksplit (internal, internal),
	FUNCTION	7	ganyarray_same (ganyarray, ganyarray, internal),
STORAGE         ganyarray;

CREATE OPERATOR CLASS _timestamptz_aa_ops
FOR TYPE _timestamptz USING gist
AS
	OPERATOR	3	&&	(anyarray, anyarray),
	OPERATOR	6	=	(anyarray, anyarray),
	OPERATOR	7	@>	(anyarray, anyarray),
	OPERATOR	8	<@	(anyarray, anyarray),
	OPERATOR	16	%	(anyarray, anyarray),
	FUNCTION	1	ganyarray_consistent(internal,internal,int,oid,internal),
	FUNCTION	2	ganyarray_union (bytea, internal),
	FUNCTION	3	ganyarray_compress (internal),
	FUNCTION	4	ganyarray_decompress (internal),
	FUNCTION	5	ganyarray_penalty (internal, internal, internal),
	FUNCTION	6	ganyarray_picksplit (internal, internal),
	FUNCTION	7	ganyarray_same (ganyarray, ganyarray, internal),
STORAGE         ganyarray;

CREATE OPERATOR CLASS _time_aa_ops
FOR TYPE _time USING gist
AS
	OPERATOR	3	&&	(anyarray, anyarray),
	OPERATOR	6	=	(anyarray, anyarray),
	OPERATOR	7	@>	(anyarray, anyarray),
	OPERATOR	8	<@	(anyarray, anyarray),
	OPERATOR	16	%	(anyarray, anyarray),
	FUNCTION	1	ganyarray_consistent(internal,internal,int,oid,internal),
	FUNCTION	2	ganyarray_union (bytea, internal),
	FUNCTION	3	ganyarray_compress (internal),
	FUNCTION	4	ganyarray_decompress (internal),
	FUNCTION	5	ganyarray_penalty (internal, internal, internal),
	FUNCTION	6	ganyarray_picksplit (internal, internal),
	FUNCTION	7	ganyarray_same (ganyarray, ganyarray, internal),
STORAGE         ganyarray;

CREATE OPERATOR CLASS _timetz_aa_ops
FOR TYPE _timetz USING gist
AS
	OPERATOR	3	&&	(anyarray, anyarray),
	OPERATOR	6	=	(anyarray, anyarray),
	OPERATOR	7	@>	(anyarray, anyarray),
	OPERATOR	8	<@	(anyarray, anyarray),
	OPERATOR	16	%	(anyarray, anyarray),
	FUNCTION	1	ganyarray_consistent(internal,internal,int,oid,internal),
	FUNCTION	2	ganyarray_union (bytea, internal),
	FUNCTION	3	ganyarray_compress (internal),
	FUNCTION	4	ganyarray_decompress (internal),
	FUNCTION	5	ganyarray_penalty (internal, internal, internal),
	FUNCTION	6	ganyarray_picksplit (internal, internal),
	FUNCTION	7	ganyarray_same (ganyarray, ganyarray, internal),
STORAGE         ganyarray;

CREATE OPERATOR CLASS _date_aa_ops
FOR TYPE _date USING gist
AS
	OPERATOR	3	&&	(anyarray, anyarray),
	OPERATOR	6	=	(anyarray, anyarray),
	OPERATOR	7	@>	(anyarray, anyarray),
	OPERATOR	8	<@	(anyarray, anyarray),
	OPERATOR	16	%	(anyarray, anyarray),
	FUNCTION	1	ganyarray_consistent(internal,internal,int,oid,internal),
	FUNCTION	2	ganyarray_union (bytea, internal),
	FUNCTION	3	ganyarray_compress (internal),
	FUNCTION	4	ganyarray_decompress (internal),
	FUNCTION	5	ganyarray_penalty (internal, internal, internal),
	FUNCTION	6	ganyarray_picksplit (internal, internal),
	FUNCTION	7	ganyarray_same (ganyarray, ganyarray, internal),
STORAGE         ganyarray;

CREATE OPERATOR CLASS _interval_aa_ops
FOR TYPE _interval USING gist
AS
	OPERATOR	3	&&	(anyarray, anyarray),
	OPERATOR	6	=	(anyarray, anyarray),
	OPERATOR	7	@>	(anyarray, anyarray),
	OPERATOR	8	<@	(anyarray, anyarray),
	OPERATOR	16	%	(anyarray, anyarray),
	FUNCTION	1	ganyarray_consistent(internal,internal,int,oid,internal),
	FUNCTION	2	ganyarray_union (bytea, internal),
	FUNCTION	3	ganyarray_compress (internal),
	FUNCTION	4	ganyarray_decompress (internal),
	FUNCTION	5	ganyarray_penalty (internal, internal, internal),
	FUNCTION	6	ganyarray_picksplit (internal, internal),
	FUNCTION	7	ganyarray_same (ganyarray, ganyarray, internal),
STORAGE         ganyarray;

CREATE OPERATOR CLASS _macaddr_aa_ops
FOR TYPE _macaddr USING gist
AS
	OPERATOR	3	&&	(anyarray, anyarray),
	OPERATOR	6	=	(anyarray, anyarray),
	OPERATOR	7	@>	(anyarray, anyarray),
	OPERATOR	8	<@	(anyarray, anyarray),
	OPERATOR	16	%	(anyarray, anyarray),
	FUNCTION	1	ganyarray_consistent(internal,internal,int,oid,internal),
	FUNCTION	2	ganyarray_union (bytea, internal),
	FUNCTION	3	ganyarray_compress (internal),
	FUNCTION	4	ganyarray_decompress (internal),
	FUNCTION	5	ganyarray_penalty (internal, internal, internal),
	FUNCTION	6	ganyarray_picksplit (internal, internal),
	FUNCTION	7	ganyarray_same (ganyarray, ganyarray, internal),
STORAGE         ganyarray;

CREATE OPERATOR CLASS _inet_aa_ops
FOR TYPE _inet USING gist
AS
	OPERATOR	3	&&	(anyarray, anyarray),
	OPERATOR	6	=	(anyarray, anyarray),
	OPERATOR	7	@>	(anyarray, anyarray),
	OPERATOR	8	<@	(anyarray, anyarray),
	OPERATOR	16	%	(anyarray, anyarray),
	FUNCTION	1	ganyarray_consistent(internal,internal,int,oid,internal),
	FUNCTION	2	ganyarray_union (bytea, internal),
	FUNCTION	3	ganyarray_compress (internal),
	FUNCTION	4	ganyarray_decompress (internal),
	FUNCTION	5	ganyarray_penalty (internal, internal, internal),
	FUNCTION	6	ganyarray_picksplit (internal, internal),
	FUNCTION	7	ganyarray_same (ganyarray, ganyarray, internal),
STORAGE         ganyarray;

CREATE OPERATOR CLASS _cidr_aa_ops
FOR TYPE _cidr USING gist
AS
	OPERATOR	3	&&	(anyarray, anyarray),
	OPERATOR	6	=	(anyarray, anyarray),
	OPERATOR	7	@>	(anyarray, anyarray),
	OPERATOR	8	<@	(anyarray, anyarray),
	OPERATOR	16	%	(anyarray, anyarray),
	FUNCTION	1	ganyarray_consistent(internal,internal,int,oid,internal),
	FUNCTION	2	ganyarray_union (bytea, internal),
	FUNCTION	3	ganyarray_compress (internal),
	FUNCTION	4	ganyarray_decompress (internal),
	FUNCTION	5	ganyarray_penalty (internal, internal, internal),
	FUNCTION	6	ganyarray_picksplit (internal, internal),
	FUNCTION	7	ganyarray_same (ganyarray, ganyarray, internal),
STORAGE         ganyarray;

CREATE OPERATOR CLASS _text_aa_ops
FOR TYPE _text USING gist
AS
	OPERATOR	3	&&	(anyarray, anyarray),
	OPERATOR	6	=	(anyarray, anyarray),
	OPERATOR	7	@>	(anyarray, anyarray),
	OPERATOR	8	<@	(anyarray, anyarray),
	OPERATOR	16	%	(anyarray, anyarray),
	FUNCTION	1	ganyarray_consistent(internal,internal,int,oid,internal),
	FUNCTION	2	ganyarray_union (bytea, internal),
	FUNCTION	3	ganyarray_compress (internal),
	FUNCTION	4	ganyarray_decompress (internal),
	FUNCTION	5	ganyarray_penalty (internal, internal, internal),
	FUNCTION	6	ganyarray_picksplit (internal, internal),
	FUNCTION	7	ganyarray_same (ganyarray, ganyarray, internal),
STORAGE         ganyarray;

CREATE OPERATOR CLASS _varchar_aa_ops
FOR TYPE _varchar USING gist
AS
	OPERATOR	3	&&	(anyarray, anyarray),
	OPERATOR	6	=	(anyarray, anyarray),
	OPERATOR	7	@>	(anyarray, anyarray),
	OPERATOR	8	<@	(anyarray, anyarray),
	OPERATOR	16	%	(anyarray, anyarray),
	FUNCTION	1	ganyarray_consistent(internal,internal,int,oid,internal),
	FUNCTION	2	ganyarray_union (bytea, internal),
	FUNCTION	3	ganyarray_compress (internal),
	FUNCTION	4	ganyarray_decompress (internal),
	FUNCTION	5	ganyarray_penalty (internal, internal, internal),
	FUNCTION	6	ganyarray_picksplit (internal, internal),
	FUNCTION	7	ganyarray_same (ganyarray, ganyarray, internal),
STORAGE         ganyarray;

CREATE OPERATOR CLASS _char_aa_ops
FOR TYPE _char USING gist
AS
	OPERATOR	3	&&	(anyarray, anyarray),
	OPERATOR	6	=	(anyarray, anyarray),
	OPERATOR	7	@>	(anyarray, anyarray),
	OPERATOR	8	<@	(anyarray, anyarray),
	OPERATOR	16	%	(anyarray, anyarray),
	FUNCTION	1	ganyarray_consistent(internal,internal,int,oid,internal),
	FUNCTION	2	ganyarray_union (bytea, internal),
	FUNCTION	3	ganyarray_compress (internal),
	FUNCTION	4	ganyarray_decompress (internal),
	FUNCTION	5	ganyarray_penalty (internal, internal, internal),
	FUNCTION	6	ganyarray_picksplit (internal, internal),
	FUNCTION	7	ganyarray_same (ganyarray, ganyarray, internal),
STORAGE         ganyarray;

CREATE OPERATOR CLASS _bytea_aa_ops
FOR TYPE _bytea USING gist
AS
	OPERATOR	3	&&	(anyarray, anyarray),
	OPERATOR	6	=	(anyarray, anyarray),
	OPERATOR	7	@>	(anyarray, anyarray),
	OPERATOR	8	<@	(anyarray, anyarray),
	OPERATOR	16	%	(anyarray, anyarray),
	FUNCTION	1	ganyarray_consistent(internal,internal,int,oid,internal),
	FUNCTION	2	ganyarray_union (bytea, internal),
	FUNCTION	3	ganyarray_compress (internal),
	FUNCTION	4	ganyarray_decompress (internal),
	FUNCTION	5	ganyarray_penalty (internal, internal, internal),
	FUNCTION	6	ganyarray_picksplit (internal, internal),
	FUNCTION	7	ganyarray_same (ganyarray, ganyarray, internal),
STORAGE         ganyarray;

CREATE OPERATOR CLASS _numeric_aa_ops
FOR TYPE _numeric USING gist
AS
	OPERATOR	3	&&	(anyarray, anyarray),
	OPERATOR	6	=	(anyarray, anyarray),
	OPERATOR	7	@>	(anyarray, anyarray),
	OPERATOR	8	<@	(anyarray, anyarray),
	OPERATOR	16	%	(anyarray, anyarray),
	FUNCTION	1	ganyarray_consistent(internal,internal,int,oid,internal),
	FUNCTION	2	ganyarray_union (bytea, internal),
	FUNCTION	3	ganyarray_compress (internal),
	FUNCTION	4	ganyarray_decompress (internal),
	FUNCTION	5	ganyarray_penalty (internal, internal, internal),
	FUNCTION	6	ganyarray_picksplit (internal, internal),
	FUNCTION	7	ganyarray_same (ganyarray, ganyarray, internal),
STORAGE         ganyarray;

--gin support functions
CREATE OR REPLACE FUNCTION ginanyarray_extract(anyarray, internal)
	RETURNS internal
	AS 'MODULE_PATHNAME'
	LANGUAGE C IMMUTABLE;

CREATE OR REPLACE FUNCTION ginanyarray_queryextract(anyarray, internal, internal)
	RETURNS internal
	AS 'MODULE_PATHNAME'
	LANGUAGE C IMMUTABLE;

CREATE OR REPLACE FUNCTION ginanyarray_consistent(internal, internal, anyarray)
	RETURNS internal
	AS 'MODULE_PATHNAME'
	LANGUAGE C IMMUTABLE;

--gin opclasses

CREATE OPERATOR CLASS _int2_aa_ops
FOR TYPE _int2	USING gin
AS
	OPERATOR	3	&&	(anyarray, anyarray),
	OPERATOR	6	=	(anyarray, anyarray),
	OPERATOR	7	@>	(anyarray, anyarray),
	OPERATOR	8	<@	(anyarray, anyarray),
	OPERATOR	16	%	(anyarray, anyarray),
	FUNCTION	1	btint2cmp(int2,int2),
	FUNCTION	2	ginanyarray_extract(anyarray, internal),
	FUNCTION	3	ginanyarray_queryextract(anyarray, internal, internal),
	FUNCTION	4	ginanyarray_consistent(internal, internal, anyarray),
	STORAGE		int2;
CREATE OPERATOR CLASS _int4_aa_ops
FOR TYPE _int4  USING gin
AS
    OPERATOR	3	&&	(anyarray, anyarray),
	OPERATOR	6	=	(anyarray, anyarray),
	OPERATOR	7	@>	(anyarray, anyarray),
	OPERATOR	8	<@	(anyarray, anyarray),
	OPERATOR	16	%	(anyarray, anyarray),
	FUNCTION    1   btint4cmp(int4,int4),
	FUNCTION    2   ginanyarray_extract(anyarray, internal),
	FUNCTION    3   ginanyarray_queryextract(anyarray, internal, internal),
	FUNCTION    4   ginanyarray_consistent(internal, internal, anyarray),
	STORAGE     int4;

CREATE OPERATOR CLASS _int8_aa_ops
FOR TYPE _int8  USING gin
AS
    OPERATOR	3	&&	(anyarray, anyarray),
	OPERATOR	6	=	(anyarray, anyarray),
	OPERATOR	7	@>	(anyarray, anyarray),
	OPERATOR	8	<@	(anyarray, anyarray),
	OPERATOR	16	%	(anyarray, anyarray),
	FUNCTION    1   btint8cmp(int8,int8),
	FUNCTION    2   ginanyarray_extract(anyarray, internal),
	FUNCTION    3   ginanyarray_queryextract(anyarray, internal, internal),
	FUNCTION    4   ginanyarray_consistent(internal, internal, anyarray),
	STORAGE     int8;

CREATE OPERATOR CLASS _float4_aa_ops
FOR TYPE _float4  USING gin
AS
    OPERATOR	3	&&	(anyarray, anyarray),
	OPERATOR	6	=	(anyarray, anyarray),
	OPERATOR	7	@>	(anyarray, anyarray),
	OPERATOR	8	<@	(anyarray, anyarray),
	OPERATOR	16	%	(anyarray, anyarray),
	FUNCTION    1   btfloat4cmp(float4,float4),
	FUNCTION    2   ginanyarray_extract(anyarray, internal),
	FUNCTION    3   ginanyarray_queryextract(anyarray, internal, internal),
	FUNCTION    4   ginanyarray_consistent(internal, internal, anyarray),
	STORAGE     float4;

CREATE OPERATOR CLASS _float8_aa_ops
FOR TYPE _float8  USING gin
AS
    OPERATOR	3	&&	(anyarray, anyarray),
	OPERATOR	6	=	(anyarray, anyarray),
	OPERATOR	7	@>	(anyarray, anyarray),
	OPERATOR	8	<@	(anyarray, anyarray),
	OPERATOR	16	%	(anyarray, anyarray),
	FUNCTION    1   btfloat8cmp(float8,float8),
	FUNCTION    2   ginanyarray_extract(anyarray, internal),
	FUNCTION    3   ginanyarray_queryextract(anyarray, internal, internal),
	FUNCTION    4   ginanyarray_consistent(internal, internal, anyarray),
	STORAGE     float8;

CREATE OPERATOR CLASS _money_aa_ops
FOR TYPE _money  USING gin
AS
    OPERATOR	3	&&	(anyarray, anyarray),
	OPERATOR	6	=	(anyarray, anyarray),
	OPERATOR	7	@>	(anyarray, anyarray),
	OPERATOR	8	<@	(anyarray, anyarray),
	OPERATOR	16	%	(anyarray, anyarray),
	FUNCTION    1   cash_cmp(money,money),
	FUNCTION    2   ginanyarray_extract(anyarray, internal),
	FUNCTION    3   ginanyarray_queryextract(anyarray, internal, internal),
	FUNCTION    4   ginanyarray_consistent(internal, internal, anyarray),
	STORAGE     money;

CREATE OPERATOR CLASS _oid_aa_ops
FOR TYPE _oid  USING gin
AS
    OPERATOR	3	&&	(anyarray, anyarray),
	OPERATOR	6	=	(anyarray, anyarray),
	OPERATOR	7	@>	(anyarray, anyarray),
	OPERATOR	8	<@	(anyarray, anyarray),
	OPERATOR	16	%	(anyarray, anyarray),
	FUNCTION    1   btoidcmp(oid,oid),
	FUNCTION    2   ginanyarray_extract(anyarray, internal),
	FUNCTION    3   ginanyarray_queryextract(anyarray, internal, internal),
	FUNCTION    4   ginanyarray_consistent(internal, internal, anyarray),
	STORAGE     oid;

CREATE OPERATOR CLASS _timestamp_aa_ops
FOR TYPE _timestamp  USING gin
AS
    OPERATOR	3	&&	(anyarray, anyarray),
	OPERATOR	6	=	(anyarray, anyarray),
	OPERATOR	7	@>	(anyarray, anyarray),
	OPERATOR	8	<@	(anyarray, anyarray),
	OPERATOR	16	%	(anyarray, anyarray),
	FUNCTION    1   timestamp_cmp(timestamp,timestamp),
	FUNCTION    2   ginanyarray_extract(anyarray, internal),
	FUNCTION    3   ginanyarray_queryextract(anyarray, internal, internal),
	FUNCTION    4   ginanyarray_consistent(internal, internal, anyarray),
	STORAGE     timestamp;

CREATE OPERATOR CLASS _timestamptz_aa_ops
FOR TYPE _timestamptz  USING gin
AS
    OPERATOR	3	&&	(anyarray, anyarray),
	OPERATOR	6	=	(anyarray, anyarray),
	OPERATOR	7	@>	(anyarray, anyarray),
	OPERATOR	8	<@	(anyarray, anyarray),
	OPERATOR	16	%	(anyarray, anyarray),
	FUNCTION    1   timestamptz_cmp(timestamptz,timestamptz),
	FUNCTION    2   ginanyarray_extract(anyarray, internal),
	FUNCTION    3   ginanyarray_queryextract(anyarray, internal, internal),
	FUNCTION    4   ginanyarray_consistent(internal, internal, anyarray),
	STORAGE     timestamptz;

CREATE OPERATOR CLASS _time_aa_ops
FOR TYPE _time  USING gin
AS
    OPERATOR	3	&&	(anyarray, anyarray),
	OPERATOR	6	=	(anyarray, anyarray),
	OPERATOR	7	@>	(anyarray, anyarray),
	OPERATOR	8	<@	(anyarray, anyarray),
	OPERATOR	16	%	(anyarray, anyarray),
	FUNCTION    1   time_cmp(time,time),
	FUNCTION    2   ginanyarray_extract(anyarray, internal),
	FUNCTION    3   ginanyarray_queryextract(anyarray, internal, internal),
	FUNCTION    4   ginanyarray_consistent(internal, internal, anyarray),
	STORAGE     time;

CREATE OPERATOR CLASS _timetz_aa_ops
FOR TYPE _timetz  USING gin
AS
    OPERATOR	3	&&	(anyarray, anyarray),
	OPERATOR	6	=	(anyarray, anyarray),
	OPERATOR	7	@>	(anyarray, anyarray),
	OPERATOR	8	<@	(anyarray, anyarray),
	OPERATOR	16	%	(anyarray, anyarray),
	FUNCTION    1   timetz_cmp(timetz,timetz),
	FUNCTION    2   ginanyarray_extract(anyarray, internal),
	FUNCTION    3   ginanyarray_queryextract(anyarray, internal, internal),
	FUNCTION    4   ginanyarray_consistent(internal, internal, anyarray),
	STORAGE     timetz;

CREATE OPERATOR CLASS _date_aa_ops
FOR TYPE _date  USING gin
AS
    OPERATOR	3	&&	(anyarray, anyarray),
	OPERATOR	6	=	(anyarray, anyarray),
	OPERATOR	7	@>	(anyarray, anyarray),
	OPERATOR	8	<@	(anyarray, anyarray),
	OPERATOR	16	%	(anyarray, anyarray),
	FUNCTION    1   date_cmp(date,date),
	FUNCTION    2   ginanyarray_extract(anyarray, internal),
	FUNCTION    3   ginanyarray_queryextract(anyarray, internal, internal),
	FUNCTION    4   ginanyarray_consistent(internal, internal, anyarray),
	STORAGE     date;

CREATE OPERATOR CLASS _interval_aa_ops
FOR TYPE _interval  USING gin
AS
    OPERATOR	3	&&	(anyarray, anyarray),
	OPERATOR	6	=	(anyarray, anyarray),
	OPERATOR	7	@>	(anyarray, anyarray),
	OPERATOR	8	<@	(anyarray, anyarray),
	OPERATOR	16	%	(anyarray, anyarray),
	FUNCTION    1   interval_cmp(interval,interval),
	FUNCTION    2   ginanyarray_extract(anyarray, internal),
	FUNCTION    3   ginanyarray_queryextract(anyarray, internal, internal),
	FUNCTION    4   ginanyarray_consistent(internal, internal, anyarray),
	STORAGE     interval;

CREATE OPERATOR CLASS _macaddr_aa_ops
FOR TYPE _macaddr  USING gin
AS
    OPERATOR	3	&&	(anyarray, anyarray),
	OPERATOR	6	=	(anyarray, anyarray),
	OPERATOR	7	@>	(anyarray, anyarray),
	OPERATOR	8	<@	(anyarray, anyarray),
	OPERATOR	16	%	(anyarray, anyarray),
	FUNCTION    1   macaddr_cmp(macaddr,macaddr),
	FUNCTION    2   ginanyarray_extract(anyarray, internal),
	FUNCTION    3   ginanyarray_queryextract(anyarray, internal, internal),
	FUNCTION    4   ginanyarray_consistent(internal, internal, anyarray),
	STORAGE     macaddr;

CREATE OPERATOR CLASS _inet_aa_ops
FOR TYPE _inet  USING gin
AS
    OPERATOR	3	&&	(anyarray, anyarray),
	OPERATOR	6	=	(anyarray, anyarray),
	OPERATOR	7	@>	(anyarray, anyarray),
	OPERATOR	8	<@	(anyarray, anyarray),
	OPERATOR	16	%	(anyarray, anyarray),
	FUNCTION    1   network_cmp(inet,inet),
	FUNCTION    2   ginanyarray_extract(anyarray, internal),
	FUNCTION    3   ginanyarray_queryextract(anyarray, internal, internal),
	FUNCTION    4   ginanyarray_consistent(internal, internal, anyarray),
	STORAGE     inet;

CREATE OPERATOR CLASS _cidr_aa_ops
FOR TYPE _cidr  USING gin
AS
    OPERATOR	3	&&	(anyarray, anyarray),
	OPERATOR	6	=	(anyarray, anyarray),
	OPERATOR	7	@>	(anyarray, anyarray),
	OPERATOR	8	<@	(anyarray, anyarray),
	OPERATOR	16	%	(anyarray, anyarray),
	FUNCTION    1   network_cmp(inet,inet),
	FUNCTION    2   ginanyarray_extract(anyarray, internal),
	FUNCTION    3   ginanyarray_queryextract(anyarray, internal, internal),
	FUNCTION    4   ginanyarray_consistent(internal, internal, anyarray),
	STORAGE     cidr;

CREATE OPERATOR CLASS _text_aa_ops
FOR TYPE _text  USING gin
AS
    OPERATOR	3	&&	(anyarray, anyarray),
	OPERATOR	6	=	(anyarray, anyarray),
	OPERATOR	7	@>	(anyarray, anyarray),
	OPERATOR	8	<@	(anyarray, anyarray),
	OPERATOR	16	%	(anyarray, anyarray),
	FUNCTION    1   bttextcmp(text,text),
	FUNCTION    2   ginanyarray_extract(anyarray, internal),
	FUNCTION    3   ginanyarray_queryextract(anyarray, internal, internal),
	FUNCTION    4   ginanyarray_consistent(internal, internal, anyarray),
	STORAGE     text;

CREATE OPERATOR CLASS _varchar_aa_ops
FOR TYPE _varchar  USING gin
AS
    OPERATOR	3	&&	(anyarray, anyarray),
	OPERATOR	6	=	(anyarray, anyarray),
	OPERATOR	7	@>	(anyarray, anyarray),
	OPERATOR	8	<@	(anyarray, anyarray),
	OPERATOR	16	%	(anyarray, anyarray),
	FUNCTION    1   bttextcmp(text,text),
	FUNCTION    2   ginanyarray_extract(anyarray, internal),
	FUNCTION    3   ginanyarray_queryextract(anyarray, internal, internal),
	FUNCTION    4   ginanyarray_consistent(internal, internal, anyarray),
	STORAGE     varchar;

CREATE OPERATOR CLASS _char_aa_ops
FOR TYPE "_char"  USING gin
AS
    OPERATOR	3	&&	(anyarray, anyarray),
	OPERATOR	6	=	(anyarray, anyarray),
	OPERATOR	7	@>	(anyarray, anyarray),
	OPERATOR	8	<@	(anyarray, anyarray),
	OPERATOR	16	%	(anyarray, anyarray),
	FUNCTION    1   btcharcmp("char","char"),
	FUNCTION    2   ginanyarray_extract(anyarray, internal),
	FUNCTION    3   ginanyarray_queryextract(anyarray, internal, internal),
	FUNCTION    4   ginanyarray_consistent(internal, internal, anyarray),
	STORAGE     "char";

CREATE OPERATOR CLASS _bytea_aa_ops
FOR TYPE _bytea  USING gin
AS
    OPERATOR	3	&&	(anyarray, anyarray),
	OPERATOR	6	=	(anyarray, anyarray),
	OPERATOR	7	@>	(anyarray, anyarray),
	OPERATOR	8	<@	(anyarray, anyarray),
	OPERATOR	16	%	(anyarray, anyarray),
	FUNCTION    1   byteacmp(bytea,bytea),
	FUNCTION    2   ginanyarray_extract(anyarray, internal),
	FUNCTION    3   ginanyarray_queryextract(anyarray, internal, internal),
	FUNCTION    4   ginanyarray_consistent(internal, internal, anyarray),
	STORAGE     bytea;

CREATE OPERATOR CLASS _bit_aa_ops
FOR TYPE _bit  USING gin
AS
    OPERATOR	3	&&	(anyarray, anyarray),
	OPERATOR	6	=	(anyarray, anyarray),
	OPERATOR	7	@>	(anyarray, anyarray),
	OPERATOR	8	<@	(anyarray, anyarray),
	OPERATOR	16	%	(anyarray, anyarray),
	FUNCTION    1   bitcmp(bit,bit),
	FUNCTION    2   ginanyarray_extract(anyarray, internal),
	FUNCTION    3   ginanyarray_queryextract(anyarray, internal, internal),
	FUNCTION    4   ginanyarray_consistent(internal, internal, anyarray),
	STORAGE     bit;

CREATE OPERATOR CLASS _varbit_aa_ops
FOR TYPE _varbit  USING gin
AS
    OPERATOR	3	&&	(anyarray, anyarray),
	OPERATOR	6	=	(anyarray, anyarray),
	OPERATOR	7	@>	(anyarray, anyarray),
	OPERATOR	8	<@	(anyarray, anyarray),
	OPERATOR	16	%	(anyarray, anyarray),
	FUNCTION    1   varbitcmp(varbit,varbit),
	FUNCTION    2   ginanyarray_extract(anyarray, internal),
	FUNCTION    3   ginanyarray_queryextract(anyarray, internal, internal),
	FUNCTION    4   ginanyarray_consistent(internal, internal, anyarray),
	STORAGE     varbit;

CREATE OPERATOR CLASS _numeric_aa_ops
FOR TYPE _numeric  USING gin
AS
    OPERATOR	3	&&	(anyarray, anyarray),
	OPERATOR	6	=	(anyarray, anyarray),
	OPERATOR	7	@>	(anyarray, anyarray),
	OPERATOR	8	<@	(anyarray, anyarray),
	OPERATOR	16	%	(anyarray, anyarray),
	FUNCTION    1   numeric_cmp(numeric,numeric),
	FUNCTION    2   ginanyarray_extract(anyarray, internal),
	FUNCTION    3   ginanyarray_queryextract(anyarray, internal, internal),
	FUNCTION    4   ginanyarray_consistent(internal, internal, anyarray),
	STORAGE     numeric;