Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit99fd638

Browse files
committed
btree_gist: Merge the last two versions into version 1.8
During the development cycle of v18, btree_gist has been bumped once to1.8 for the addition of translate_cmptype support functions (originally7406ab6, renamed in32edf73). 1.9 has added sortsupportfunctions (e4309f7).There is no need for two version bumps in a module for a single majorrelease of PostgreSQL. This commit unifies both upgrades to a singleSQL 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.comBackpatch-through: 18
1 parent7bd752c commit99fd638

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

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp