8000 btree_gist: Merge the last two versions into version 1.8 · postgres/postgres@b41c430 · GitHub
[go: up one dir, main page]
Skip to content

Commit b41c430

Browse files
michaelpqmichaelpq
committed
btree_gist: Merge the last two versions into version 1.8
During the development cycle of v18, btree_gist has been bumped once to 1.8 for the addition of translate_cmptype support functions (originally 7406ab6, renamed in 32edf73). 1.9 has added sortsupport functions (e4309f7). There is no need for two version bumps in a module for a single major release of PostgreSQL. This commit unifies both upgrades to a single SQL script, downgrading btree_gist to 1.8. Author: Paul A. Jungwirth <pj@illuminatedcomputing.com> Reviewed-by: Tom Lane <tgl@sss.pgh.pa.us> Discussion: https://postgr.es/m/13c61807-f702-4afe-9a8d-795e2fd40923@illuminatedcomputing.com Backpatch-through: 18
1 parent 4eca711 commit b41c430

File tree

5 files changed

+199
-200
lines changed

5 files changed

+199
-200
lines changed

‎contrib/btree_gist/Makefile

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -34,7 +34,7 @@ DATA = btree_gist--1.0--1.1.sql \
3434
btree_gist--1.1--1.2.sql btree_gist--1.2.sql btree_gist--1.2--1.3.sql \
3535
btree_gist--1.3--1.4.sql btree_gist--1.4--1.5.sql \
3636
btree_gist--1.5--1.6.sql btree_gist--1.6--1.7.sql \
37-
btree_gist--1.7--1.8.sql btree_gist--1.8--1.9.sql
37+
btree_gist--1.7--1.8.sql
3838
PGFILEDESC = "btree_gist - B-tree equivalent GiST operator classes"
3939

4040
REGRESS = init int2 int4 int8 float4 float8 cash oid timestamp timestamptz \

‎contrib/btree_gist/btree_gist--1.7--1.8.sql

Lines changed: 197 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -3,6 +3,203 @@
33
-- complain if script is sourced in psql, rather than via CREATE EXTENSION
44
\echo Use "ALTER EXTENSION btree_gist UPDATE TO '1.8'" to load this file. \quit
55

6+
-- Add sortsupport functions
7+
8+
CREATE FUNCTION gbt_bit_sortsupport(internal)
9+
RETURNS void
10+
AS 'MODULE_PATHNAME'
11+
LANGUAGE C IMMUTABLE PARALLEL SAFE STRICT;
12+
13+
CREATE FUNCTION gbt_varbit_sortsupport(internal)
14+
RETURNS void
15+
AS 'MODULE_PATHNAME'
16+
LANGUAGE C IMMUTABLE PARALLEL SAFE STRICT;
17+
18+
CREATE FUNCTION gbt_bool_sortsupport(internal)
19+
RETURNS void
20+
AS 'MODULE_PATHNAME'
21+
LANGUAGE C IMMUTABLE PARALLEL SAFE STRICT;
22+
23+
CREATE FUNCTION gbt_bytea_sortsupport(internal)
24+
RETURNS void
25+
AS 'MODULE_PATHNAME'
26+
LANGUAGE C IMMUTABLE PARALLEL SAFE STRICT;
27+
28+
CREATE FUNCTION gbt_cash_sortsupport(internal)
29+
RETURNS void
30+
AS 'MODULE_PATHNAME'
31+
LANGUAGE C IMMUTABLE PARALLEL SAFE STRICT;
32+
33+
CREATE FUNCTION gbt_date_sortsupport(internal)
34+
RETURNS void
35+
AS 'MODULE_PATHNAME'
36+
LANGUAGE C IMMUTABLE PARALLEL SAFE STRICT;
37+
38+
CREATE FUNCTION gbt_enum_sortsupport(internal)
39+
RETURNS void
40+
AS 'MODULE_PATHNAME'
41+
LANGUAGE C IMMUTABLE PARALLEL SAFE STRICT;
42+
43+
CREATE FUNCTION gbt_float4_sortsupport(internal)
44+
RETURNS void
45+
AS 'MODULE_PATHNAME'
46+
LANGUAGE C IMMUTABLE PARALLEL SAFE STRICT;
47+
48+
CREATE FUNCTION gbt_float8_sortsupport(internal)
49+
RETURNS void
50+
AS 'MODULE_PATHNAME'
51+
LANGUAGE C IMMUTABLE PARALLEL SAFE STRICT;
52+
53+
CREATE FUNCTION gbt_inet_sortsupport(internal)
54+
RETURNS void
55+
AS 'MODULE_PATHNAME'
56+
LANGUAGE C IMMUTABLE PARALLEL SAFE STRICT;
57+
58+
CREATE FUNCTION gbt_int2_sortsupport(internal)
59+
RETURNS void
60+
AS 'MODULE_PATHNAME'
61+
LANGUAGE C IMMUTABLE PARALLEL SAFE STRICT;
62+
63+
CREATE FUNCTION gbt_int4_sortsupport(internal)
64+
RETURNS void
65+
AS 'MODULE_PATHNAME'
66+
LANGUAGE C IMMUTABLE PARALLEL SAFE STRICT;
67+
68+
CREATE FUNCTION gbt_int8_sortsupport(internal)
69+
RETURNS void
70+
AS 'MODULE_PATHNAME'
71+
LANGUAGE C IMMUTABLE PARALLEL SAFE STRICT;
72+
73+
CREATE FUNCTION gbt_intv_sortsupport(internal)
74+
RETURNS void
75+
AS 'MODULE_PATHNAME'
76+
LANGUAGE C IMMUTABLE PARALLEL SAFE STRICT;
77+
78+
CREATE FUNCTION gbt_macaddr_sortsupport(internal)
79+
RETURNS void
80+
AS 'MODULE_PATHNAME'
81+
LANGUAGE C IMMUTABLE PARALLEL SAFE STRICT;
82+
83+
CREATE FUNCTION gbt_macad8_sortsupport(internal)
84+
RETURNS void
85+
AS 'MODULE_PATHNAME'
86+
LANGUAGE C IMMUTABLE PARALLEL SAFE STRICT;
87+
88+
CREATE FUNCTION gbt_numeric_sortsupport(internal)
89+
RETURNS void
90+
AS 'MODULE_PATHNAME'
91+
LANGUAGE C IMMUTABLE PARALLEL SAFE STRICT;
92+
93+
CREATE FUNCTION gbt_oid_sortsupport(internal)
94+
RETURNS void
95+
AS 'MODULE_PATHNAME'
96+
LANGUAGE C IMMUTABLE PARALLEL SAFE STRICT;
97+
98+
CREATE FUNCTION gbt_text_sortsupport(internal)
99+
RETURNS void
100+
AS 'MODULE_PATHNAME'
101+
LANGUAGE C IMMUTABLE PARALLEL SAFE STRICT;
102+
103+
CREATE FUNCTION gbt_bpchar_sortsupport(internal)
104+
RETURNS void
105+
AS 'MODULE_PATHNAME'
106+
LANGUAGE C IMMUTABLE PARALLEL SAFE STRICT;
107+
108+
CREATE FUNCTION gbt_time_sortsupport(internal)
109+
RETURNS void
110+
AS 'MODULE_PATHNAME'
111+
LANGUAGE C IMMUTABLE PARALLEL SAFE STRICT;
112+
113+
CREATE FUNCTION gbt_ts_sortsupport(internal)
114+
RETURNS void
115+
AS 'MODULE_PATHNAME'
116+
LANGUAGE C IMMUTABLE PARALLEL SAFE STRICT;
117+
118+
CREATE FUNCTION gbt_uuid_sortsupport(internal)
119+
RETURNS void
120+
AS 'MODULE_PATHNAME'
121+
LANGUAGE C IMMUTABLE PARALLEL SAFE STRICT;
122+
123+
ALTER OPERATOR FAMILY gist_bit_ops USING gist ADD
124+
FUNCTION 11 (bit, bit) gbt_bit_sortsupport (internal) ;
125+
126+
ALTER OPERATOR FAMILY gist_vbit_ops USING gist ADD
127+
FUNCTION 11 (varbit, varbit) gbt_varbit_sortsupport (internal) ;
128+
129+
ALTER OPERATOR FAMILY gist_bool_ops USING gist ADD
130+
FUNCTION 11 (bool, bool) gbt_bool_sortsupport (internal) ;
131+
132+
ALTER OPERATOR FAMILY gist_bytea_ops USING gist ADD
133+
FUNCTION 11 (bytea, bytea) gbt_bytea_sortsupport (internal) ;
134+
135+
ALTER OPERATOR FAMILY gist_cash_ops USING gist ADD
136+
FUNCTION 11 (money, money) gbt_cash_sortsupport (internal) ;
137+
138+
ALTER OPERATOR FAMILY gist_date_ops USING gist ADD
139+
FUNCTION 11 (date, date) gbt_date_sortsupport (internal) ;
140+
141+
ALTER OPERATOR FAMILY gist_enum_ops USING gist ADD
142+
FUNCTION 11 (anyenum, anyenum) gbt_enum_sortsupport (internal) ;
143+
144+
ALTER OPERATOR FAMILY gist_float4_ops USING gist ADD
145+
FUNCTION 11 (float4, float4) gbt_float4_sortsupport (internal) ;
146+
147+
ALTER OPERATOR FAMILY gist_float8_ops USING gist ADD
148+
FUNCTION 11 (float8, float8) gbt_float8_sortsupport (internal) ;
149+
150+
ALTER OPERATOR FAMILY gist_inet_ops USING gist ADD
151+
FUNCTION 11 (inet, inet) gbt_inet_sortsupport (internal) ;
152+
153+
ALTER OPERATOR FAMILY gist_cidr_ops USING gist ADD
154+
FUNCTION 11 (cidr, cidr) gbt_inet_sortsupport (internal) ;
155+
156+
ALTER OPERATOR FAMILY gist_int2_ops USING gist ADD
157+
FUNCTION 11 (int2, int2) gbt_int2_sortsupport (internal) ;
158+
159+
ALTER OPERATOR FAMILY gist_int4_ops USING gist ADD
160+
FUNCTION 11 (int4, int4) gbt_int4_sortsupport (internal) ;
161+
162+
ALTER OPERATOR FAMILY gist_int8_ops USING gist ADD
163+
FUNCTION 11 (int8, int8) gbt_int8_sortsupport (internal) ;
164+
165+
ALTER OPERATOR FAMILY gist_interval_ops USING gist ADD
166+
FUNCTION 11 (interval, interval) gbt_intv_sortsupport (internal) ;
167+
168+
ALTER OPERATOR FAMILY gist_macaddr_ops USING gist ADD
169+
FUNCTION 11 (macaddr, macaddr) gbt_macaddr_sortsupport (internal) ;
170+
171+
ALTER OPERATOR FAMILY gist_macaddr8_ops USING gist ADD
172+
FUNCTION 11 (macaddr8, macaddr8) gbt_macad8_sortsupport (internal) ;
173+
174+
ALTER OPERATOR FAMILY gist_numeric_ops USING gist ADD
175+
FUNCTION 11 (numeric, numeric) gbt_numeric_sortsupport (internal) ;
176+
177+
ALTER OPERATOR FAMILY gist_oid_ops USING gist ADD
178+
FUNCTION 11 (oid, oid) gbt_oid_sortsupport (internal) ;
179+
180+
ALTER OPERATOR FAMILY gist_text_ops USING gist ADD
181+
FUNCTION 11 (text, text) gbt_text_sortsupport (internal) ;
182+
183+
ALTER OPERATOR FAMILY gist_bpchar_ops USING gist ADD
184+
FUNCTION 11 (bpchar, bpchar) gbt_bpchar_sortsupport (internal) ;
185+
186+
ALTER OPERATOR FAMILY gist_time_ops USING gist ADD
187+
FUNCTION 11 (time, time) gbt_time_sortsupport (internal) ;
188+
189+
ALTER OPERATOR FAMILY gist_timetz_ops USING gist ADD
190+
FUNCTION 11 (timetz, timetz) gbt_time_sortsupport (internal) ;
191+
192+
ALTER OPERATOR FAMILY gist_timestamp_ops USING gist ADD
193+
FUNCTION 11 (timestamp, timestamp) gbt_ts_sortsupport (internal) ;
194+
195+
ALTER OPERATOR FAMILY gist_timestamptz_ops USING gist ADD
196+
FUNCTION 11 (timestamptz, timestamptz) gbt_ts_sortsupport (internal) ;
197+
198+
ALTER OPERATOR FAMILY gist_uuid_ops USING gist ADD
199+
FUNCTION 11 (uuid, uuid) gbt_uuid_sortsupport (internal) ;
200+
201+
-- Add translate_cmptype functions
202+
6203
CREATE FUNCTION gist_translate_cmptype_btree(int)
7204
RETURNS smallint
8205
AS 'MODULE_PATHNAME'

0 commit comments

Comments
 (0)
0