1/* contrib/btree_gin/btree_gin--unpackaged--1.0.sql */ 2 3-- complain if script is sourced in psql, rather than via CREATE EXTENSION 4\echo Use "CREATE EXTENSION btree_gin FROM unpackaged" to load this file. \quit 5 6ALTER EXTENSION btree_gin ADD function gin_btree_consistent(internal,smallint,anyelement,integer,internal,internal); 7ALTER EXTENSION btree_gin ADD function gin_extract_value_int2(smallint,internal); 8ALTER EXTENSION btree_gin ADD function gin_compare_prefix_int2(smallint,smallint,smallint,internal); 9ALTER EXTENSION btree_gin ADD function gin_extract_query_int2(smallint,internal,smallint,internal,internal); 10ALTER EXTENSION btree_gin ADD operator family int2_ops using gin; 11ALTER EXTENSION btree_gin ADD operator class int2_ops using gin; 12ALTER EXTENSION btree_gin ADD function gin_extract_value_int4(integer,internal); 13ALTER EXTENSION btree_gin ADD function gin_compare_prefix_int4(integer,integer,smallint,internal); 14ALTER EXTENSION btree_gin ADD function gin_extract_query_int4(integer,internal,smallint,internal,internal); 15ALTER EXTENSION btree_gin ADD operator family int4_ops using gin; 16ALTER EXTENSION btree_gin ADD operator class int4_ops using gin; 17ALTER EXTENSION btree_gin ADD function gin_extract_value_int8(bigint,internal); 18ALTER EXTENSION btree_gin ADD function gin_compare_prefix_int8(bigint,bigint,smallint,internal); 19ALTER EXTENSION btree_gin ADD function gin_extract_query_int8(bigint,internal,smallint,internal,internal); 20ALTER EXTENSION btree_gin ADD operator family int8_ops using gin; 21ALTER EXTENSION btree_gin ADD operator class int8_ops using gin; 22ALTER EXTENSION btree_gin ADD function gin_extract_value_float4(real,internal); 23ALTER EXTENSION btree_gin ADD function gin_compare_prefix_float4(real,real,smallint,internal); 24ALTER EXTENSION btree_gin ADD function gin_extract_query_float4(real,internal,smallint,internal,internal); 25ALTER EXTENSION btree_gin ADD operator family float4_ops using gin; 26ALTER EXTENSION btree_gin ADD operator class float4_ops using gin; 27ALTER EXTENSION btree_gin ADD function gin_extract_value_float8(double precision,internal); 28ALTER EXTENSION btree_gin ADD function gin_compare_prefix_float8(double precision,double precision,smallint,internal); 29ALTER EXTENSION btree_gin ADD function gin_extract_query_float8(double precision,internal,smallint,internal,internal); 30ALTER EXTENSION btree_gin ADD operator family float8_ops using gin; 31ALTER EXTENSION btree_gin ADD operator class float8_ops using gin; 32ALTER EXTENSION btree_gin ADD function gin_extract_value_money(money,internal); 33ALTER EXTENSION btree_gin ADD function gin_compare_prefix_money(money,money,smallint,internal); 34ALTER EXTENSION btree_gin ADD function gin_extract_query_money(money,internal,smallint,internal,internal); 35ALTER EXTENSION btree_gin ADD operator family money_ops using gin; 36ALTER EXTENSION btree_gin ADD operator class money_ops using gin; 37ALTER EXTENSION btree_gin ADD function gin_extract_value_oid(oid,internal); 38ALTER EXTENSION btree_gin ADD function gin_compare_prefix_oid(oid,oid,smallint,internal); 39ALTER EXTENSION btree_gin ADD function gin_extract_query_oid(oid,internal,smallint,internal,internal); 40ALTER EXTENSION btree_gin ADD operator family oid_ops using gin; 41ALTER EXTENSION btree_gin ADD operator class oid_ops using gin; 42ALTER EXTENSION btree_gin ADD function gin_extract_value_timestamp(timestamp without time zone,internal); 43ALTER EXTENSION btree_gin ADD function gin_compare_prefix_timestamp(timestamp without time zone,timestamp without time zone,smallint,internal); 44ALTER EXTENSION btree_gin ADD function gin_extract_query_timestamp(timestamp without time zone,internal,smallint,internal,internal); 45ALTER EXTENSION btree_gin ADD operator family timestamp_ops using gin; 46ALTER EXTENSION btree_gin ADD operator class timestamp_ops using gin; 47ALTER EXTENSION btree_gin ADD function gin_extract_value_timestamptz(timestamp with time zone,internal); 48ALTER EXTENSION btree_gin ADD function gin_compare_prefix_timestamptz(timestamp with time zone,timestamp with time zone,smallint,internal); 49ALTER EXTENSION btree_gin ADD function gin_extract_query_timestamptz(timestamp with time zone,internal,smallint,internal,internal); 50ALTER EXTENSION btree_gin ADD operator family timestamptz_ops using gin; 51ALTER EXTENSION btree_gin ADD operator class timestamptz_ops using gin; 52ALTER EXTENSION btree_gin ADD function gin_extract_value_time(time without time zone,internal); 53ALTER EXTENSION btree_gin ADD function gin_compare_prefix_time(time without time zone,time without time zone,smallint,internal); 54ALTER EXTENSION btree_gin ADD function gin_extract_query_time(time without time zone,internal,smallint,internal,internal); 55ALTER EXTENSION btree_gin ADD operator family time_ops using gin; 56ALTER EXTENSION btree_gin ADD operator class time_ops using gin; 57ALTER EXTENSION btree_gin ADD function gin_extract_value_timetz(time with time zone,internal); 58ALTER EXTENSION btree_gin ADD function gin_compare_prefix_timetz(time with time zone,time with time zone,smallint,internal); 59ALTER EXTENSION btree_gin ADD function gin_extract_query_timetz(time with time zone,internal,smallint,internal,internal); 60ALTER EXTENSION btree_gin ADD operator family timetz_ops using gin; 61ALTER EXTENSION btree_gin ADD operator class timetz_ops using gin; 62ALTER EXTENSION btree_gin ADD function gin_extract_value_date(date,internal); 63ALTER EXTENSION btree_gin ADD function gin_compare_prefix_date(date,date,smallint,internal); 64ALTER EXTENSION btree_gin ADD function gin_extract_query_date(date,internal,smallint,internal,internal); 65ALTER EXTENSION btree_gin ADD operator family date_ops using gin; 66ALTER EXTENSION btree_gin ADD operator class date_ops using gin; 67ALTER EXTENSION btree_gin ADD function gin_extract_value_interval(interval,internal); 68ALTER EXTENSION btree_gin ADD function gin_compare_prefix_interval(interval,interval,smallint,internal); 69ALTER EXTENSION btree_gin ADD function gin_extract_query_interval(interval,internal,smallint,internal,internal); 70ALTER EXTENSION btree_gin ADD operator family interval_ops using gin; 71ALTER EXTENSION btree_gin ADD operator class interval_ops using gin; 72ALTER EXTENSION btree_gin ADD function gin_extract_value_macaddr(macaddr,internal); 73ALTER EXTENSION btree_gin ADD function gin_compare_prefix_macaddr(macaddr,macaddr,smallint,internal); 74ALTER EXTENSION btree_gin ADD function gin_extract_query_macaddr(macaddr,internal,smallint,internal,internal); 75ALTER EXTENSION btree_gin ADD operator family macaddr_ops using gin; 76ALTER EXTENSION btree_gin ADD operator class macaddr_ops using gin; 77ALTER EXTENSION btree_gin ADD function gin_extract_value_inet(inet,internal); 78ALTER EXTENSION btree_gin ADD function gin_compare_prefix_inet(inet,inet,smallint,internal); 79ALTER EXTENSION btree_gin ADD function gin_extract_query_inet(inet,internal,smallint,internal,internal); 80ALTER EXTENSION btree_gin ADD operator family inet_ops using gin; 81ALTER EXTENSION btree_gin ADD operator class inet_ops using gin; 82ALTER EXTENSION btree_gin ADD function gin_extract_value_cidr(cidr,internal); 83ALTER EXTENSION btree_gin ADD function gin_compare_prefix_cidr(cidr,cidr,smallint,internal); 84ALTER EXTENSION btree_gin ADD function gin_extract_query_cidr(cidr,internal,smallint,internal,internal); 85ALTER EXTENSION btree_gin ADD operator family cidr_ops using gin; 86ALTER EXTENSION btree_gin ADD operator class cidr_ops using gin; 87ALTER EXTENSION btree_gin ADD function gin_extract_value_text(text,internal); 88ALTER EXTENSION btree_gin ADD function gin_compare_prefix_text(text,text,smallint,internal); 89ALTER EXTENSION btree_gin ADD function gin_extract_query_text(text,internal,smallint,internal,internal); 90ALTER EXTENSION btree_gin ADD operator family text_ops using gin; 91ALTER EXTENSION btree_gin ADD operator class text_ops using gin; 92ALTER EXTENSION btree_gin ADD operator family varchar_ops using gin; 93ALTER EXTENSION btree_gin ADD operator class varchar_ops using gin; 94ALTER EXTENSION btree_gin ADD function gin_extract_value_char("char",internal); 95ALTER EXTENSION btree_gin ADD function gin_compare_prefix_char("char","char",smallint,internal); 96ALTER EXTENSION btree_gin ADD function gin_extract_query_char("char",internal,smallint,internal,internal); 97ALTER EXTENSION btree_gin ADD operator family char_ops using gin; 98ALTER EXTENSION btree_gin ADD operator class char_ops using gin; 99ALTER EXTENSION btree_gin ADD function gin_extract_value_bytea(bytea,internal); 100ALTER EXTENSION btree_gin ADD function gin_compare_prefix_bytea(bytea,bytea,smallint,internal); 101ALTER EXTENSION btree_gin ADD function gin_extract_query_bytea(bytea,internal,smallint,internal,internal); 102ALTER EXTENSION btree_gin ADD operator family bytea_ops using gin; 103ALTER EXTENSION btree_gin ADD operator class bytea_ops using gin; 104ALTER EXTENSION btree_gin ADD function gin_extract_value_bit(bit,internal); 105ALTER EXTENSION btree_gin ADD function gin_compare_prefix_bit(bit,bit,smallint,internal); 106ALTER EXTENSION btree_gin ADD function gin_extract_query_bit(bit,internal,smallint,internal,internal); 107ALTER EXTENSION btree_gin ADD operator family bit_ops using gin; 108ALTER EXTENSION btree_gin ADD operator class bit_ops using gin; 109ALTER EXTENSION btree_gin ADD function gin_extract_value_varbit(bit varying,internal); 110ALTER EXTENSION btree_gin ADD function gin_compare_prefix_varbit(bit varying,bit varying,smallint,internal); 111ALTER EXTENSION btree_gin ADD function gin_extract_query_varbit(bit varying,internal,smallint,internal,internal); 112ALTER EXTENSION btree_gin ADD operator family varbit_ops using gin; 113ALTER EXTENSION btree_gin ADD operator class varbit_ops using gin; 114ALTER EXTENSION btree_gin ADD function gin_extract_value_numeric(numeric,internal); 115ALTER EXTENSION btree_gin ADD function gin_compare_prefix_numeric(numeric,numeric,smallint,internal); 116ALTER EXTENSION btree_gin ADD function gin_extract_query_numeric(numeric,internal,smallint,internal,internal); 117ALTER EXTENSION btree_gin ADD function gin_numeric_cmp(numeric,numeric); 118ALTER EXTENSION btree_gin ADD operator family numeric_ops using gin; 119ALTER EXTENSION btree_gin ADD operator class numeric_ops using gin; 120