PolarDB-for-PostgreSQL

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

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