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

Commitb79b8d8

Browse files
committed
Update isn extension for parallel query.
All functions provided by this extension are PARALLEL SAFE.Andreas Karlsson
1 parent1ab194a commitb79b8d8

File tree

4 files changed

+736
-248
lines changed

4 files changed

+736
-248
lines changed

‎contrib/isn/Makefile

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -3,7 +3,7 @@
33
MODULES = isn
44

55
EXTENSION = isn
6-
DATA = isn--1.0.sql isn--unpackaged--1.0.sql
6+
DATA = isn--1.1.sql isn--1.0--1.1.sql isn--unpackaged--1.0.sql
77
PGFILEDESC = "isn - data types for international product numbering standards"
88

99
REGRESS = isn

‎contrib/isn/isn--1.0--1.1.sql

Lines changed: 250 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,250 @@
1+
/* contrib/isn/isn--1.0--1.1.sql*/
2+
3+
-- complain if script is sourced in psql, rather than via ALTER EXTENSION
4+
\echo Use"ALTER EXTENSION isn UPDATE TO '1.1'" to load this file. \quit
5+
6+
ALTERFUNCTION ean13_in(cstring) PARALLEL SAFE;
7+
ALTERFUNCTION ean13_out(ean13) PARALLEL SAFE;
8+
ALTERFUNCTION isbn13_in(cstring) PARALLEL SAFE;
9+
ALTERFUNCTION ean13_out(isbn13) PARALLEL SAFE;
10+
ALTERFUNCTION ismn13_in(cstring) PARALLEL SAFE;
11+
ALTERFUNCTION ean13_out(ismn13) PARALLEL SAFE;
12+
ALTERFUNCTION issn13_in(cstring) PARALLEL SAFE;
13+
ALTERFUNCTION ean13_out(issn13) PARALLEL SAFE;
14+
ALTERFUNCTION isbn_in(cstring) PARALLEL SAFE;
15+
ALTERFUNCTION isn_out(isbn) PARALLEL SAFE;
16+
ALTERFUNCTION ismn_in(cstring) PARALLEL SAFE;
17+
ALTERFUNCTION isn_out(ismn) PARALLEL SAFE;
18+
ALTERFUNCTION issn_in(cstring) PARALLEL SAFE;
19+
ALTERFUNCTION isn_out(issn) PARALLEL SAFE;
20+
ALTERFUNCTION upc_in(cstring) PARALLEL SAFE;
21+
ALTERFUNCTION isn_out(upc) PARALLEL SAFE;
22+
ALTERFUNCTION isnlt(ean13, ean13) PARALLEL SAFE;
23+
ALTERFUNCTION isnle(ean13, ean13) PARALLEL SAFE;
24+
ALTERFUNCTION isneq(ean13, ean13) PARALLEL SAFE;
25+
ALTERFUNCTION isnge(ean13, ean13) PARALLEL SAFE;
26+
ALTERFUNCTION isngt(ean13, ean13) PARALLEL SAFE;
27+
ALTERFUNCTION isnne(ean13, ean13) PARALLEL SAFE;
28+
ALTERFUNCTION isnlt(ean13, isbn13) PARALLEL SAFE;
29+
ALTERFUNCTION isnle(ean13, isbn13) PARALLEL SAFE;
30+
ALTERFUNCTION isneq(ean13, isbn13) PARALLEL SAFE;
31+
ALTERFUNCTION isnge(ean13, isbn13) PARALLEL SAFE;
32+
ALTERFUNCTION isngt(ean13, isbn13) PARALLEL SAFE;
33+
ALTERFUNCTION isnne(ean13, isbn13) PARALLEL SAFE;
34+
ALTERFUNCTION isnlt(ean13, ismn13) PARALLEL SAFE;
35+
ALTERFUNCTION isnle(ean13, ismn13) PARALLEL SAFE;
36+
ALTERFUNCTION isneq(ean13, ismn13) PARALLEL SAFE;
37+
ALTERFUNCTION isnge(ean13, ismn13) PARALLEL SAFE;
38+
ALTERFUNCTION isngt(ean13, ismn13) PARALLEL SAFE;
39+
ALTERFUNCTION isnne(ean13, ismn13) PARALLEL SAFE;
40+
ALTERFUNCTION isnlt(ean13, issn13) PARALLEL SAFE;
41+
ALTERFUNCTION isnle(ean13, issn13) PARALLEL SAFE;
42+
ALTERFUNCTION isneq(ean13, issn13) PARALLEL SAFE;
43+
ALTERFUNCTION isnge(ean13, issn13) PARALLEL SAFE;
44+
ALTERFUNCTION isngt(ean13, issn13) PARALLEL SAFE;
45+
ALTERFUNCTION isnne(ean13, issn13) PARALLEL SAFE;
46+
ALTERFUNCTION isnlt(ean13, isbn) PARALLEL SAFE;
47+
ALTERFUNCTION isnle(ean13, isbn) PARALLEL SAFE;
48+
ALTERFUNCTION isneq(ean13, isbn) PARALLEL SAFE;
49+
ALTERFUNCTION isnge(ean13, isbn) PARALLEL SAFE;
50+
ALTERFUNCTION isngt(ean13, isbn) PARALLEL SAFE;
51+
ALTERFUNCTION isnne(ean13, isbn) PARALLEL SAFE;
52+
ALTERFUNCTION isnlt(ean13, ismn) PARALLEL SAFE;
53+
ALTERFUNCTION isnle(ean13, ismn) PARALLEL SAFE;
54+
ALTERFUNCTION isneq(ean13, ismn) PARALLEL SAFE;
55+
ALTERFUNCTION isnge(ean13, ismn) PARALLEL SAFE;
56+
ALTERFUNCTION isngt(ean13, ismn) PARALLEL SAFE;
57+
ALTERFUNCTION isnne(ean13, ismn) PARALLEL SAFE;
58+
ALTERFUNCTION isnlt(ean13, issn) PARALLEL SAFE;
59+
ALTERFUNCTION isnle(ean13, issn) PARALLEL SAFE;
60+
ALTERFUNCTION isneq(ean13, issn) PARALLEL SAFE;
61+
ALTERFUNCTION isnge(ean13, issn) PARALLEL SAFE;
62+
ALTERFUNCTION isngt(ean13, issn) PARALLEL SAFE;
63+
ALTERFUNCTION isnne(ean13, issn) PARALLEL SAFE;
64+
ALTERFUNCTION isnlt(ean13, upc) PARALLEL SAFE;
65+
ALTERFUNCTION isnle(ean13, upc) PARALLEL SAFE;
66+
ALTERFUNCTION isneq(ean13, upc) PARALLEL SAFE;
67+
ALTERFUNCTION isnge(ean13, upc) PARALLEL SAFE;
68+
ALTERFUNCTION isngt(ean13, upc) PARALLEL SAFE;
69+
ALTERFUNCTION isnne(ean13, upc) PARALLEL SAFE;
70+
ALTERFUNCTION isnlt(isbn13, isbn13) PARALLEL SAFE;
71+
ALTERFUNCTION isnle(isbn13, isbn13) PARALLEL SAFE;
72+
ALTERFUNCTION isneq(isbn13, isbn13) PARALLEL SAFE;
73+
ALTERFUNCTION isnge(isbn13, isbn13) PARALLEL SAFE;
74+
ALTERFUNCTION isngt(isbn13, isbn13) PARALLEL SAFE;
75+
ALTERFUNCTION isnne(isbn13, isbn13) PARALLEL SAFE;
76+
ALTERFUNCTION isnlt(isbn13, isbn) PARALLEL SAFE;
77+
ALTERFUNCTION isnle(isbn13, isbn) PARALLEL SAFE;
78+
ALTERFUNCTION isneq(isbn13, isbn) PARALLEL SAFE;
79+
ALTERFUNCTION isnge(isbn13, isbn) PARALLEL SAFE;
80+
ALTERFUNCTION isngt(isbn13, isbn) PARALLEL SAFE;
81+
ALTERFUNCTION isnne(isbn13, isbn) PARALLEL SAFE;
82+
ALTERFUNCTION isnlt(isbn13, ean13) PARALLEL SAFE;
83+
ALTERFUNCTION isnle(isbn13, ean13) PARALLEL SAFE;
84+
ALTERFUNCTION isneq(isbn13, ean13) PARALLEL SAFE;
85+
ALTERFUNCTION isnge(isbn13, ean13) PARALLEL SAFE;
86+
ALTERFUNCTION isngt(isbn13, ean13) PARALLEL SAFE;
87+
ALTERFUNCTION isnne(isbn13, ean13) PARALLEL SAFE;
88+
ALTERFUNCTION isnlt(isbn, isbn) PARALLEL SAFE;
89+
ALTERFUNCTION isnle(isbn, isbn) PARALLEL SAFE;
90+
ALTERFUNCTION isneq(isbn, isbn) PARALLEL SAFE;
91+
ALTERFUNCTION isnge(isbn, isbn) PARALLEL SAFE;
92+
ALTERFUNCTION isngt(isbn, isbn) PARALLEL SAFE;
93+
ALTERFUNCTION isnne(isbn, isbn) PARALLEL SAFE;
94+
ALTERFUNCTION isnlt(isbn, isbn13) PARALLEL SAFE;
95+
ALTERFUNCTION isnle(isbn, isbn13) PARALLEL SAFE;
96+
ALTERFUNCTION isneq(isbn, isbn13) PARALLEL SAFE;
97+
ALTERFUNCTION isnge(isbn, isbn13) PARALLEL SAFE;
98+
ALTERFUNCTION isngt(isbn, isbn13) PARALLEL SAFE;
99+
ALTERFUNCTION isnne(isbn, isbn13) PARALLEL SAFE;
100+
ALTERFUNCTION isnlt(isbn, ean13) PARALLEL SAFE;
101+
ALTERFUNCTION isnle(isbn, ean13) PARALLEL SAFE;
102+
ALTERFUNCTION isneq(isbn, ean13) PARALLEL SAFE;
103+
ALTERFUNCTION isnge(isbn, ean13) PARALLEL SAFE;
104+
ALTERFUNCTION isngt(isbn, ean13) PARALLEL SAFE;
105+
ALTERFUNCTION isnne(isbn, ean13) PARALLEL SAFE;
106+
ALTERFUNCTION isnlt(ismn13, ismn13) PARALLEL SAFE;
107+
ALTERFUNCTION isnle(ismn13, ismn13) PARALLEL SAFE;
108+
ALTERFUNCTION isneq(ismn13, ismn13) PARALLEL SAFE;
109+
ALTERFUNCTION isnge(ismn13, ismn13) PARALLEL SAFE;
110+
ALTERFUNCTION isngt(ismn13, ismn13) PARALLEL SAFE;
111+
ALTERFUNCTION isnne(ismn13, ismn13) PARALLEL SAFE;
112+
ALTERFUNCTION isnlt(ismn13, ismn) PARALLEL SAFE;
113+
ALTERFUNCTION isnle(ismn13, ismn) PARALLEL SAFE;
114+
ALTERFUNCTION isneq(ismn13, ismn) PARALLEL SAFE;
115+
ALTERFUNCTION isnge(ismn13, ismn) PARALLEL SAFE;
116+
ALTERFUNCTION isngt(ismn13, ismn) PARALLEL SAFE;
117+
ALTERFUNCTION isnne(ismn13, ismn) PARALLEL SAFE;
118+
ALTERFUNCTION isnlt(ismn13, ean13) PARALLEL SAFE;
119+
ALTERFUNCTION isnle(ismn13, ean13) PARALLEL SAFE;
120+
ALTERFUNCTION isneq(ismn13, ean13) PARALLEL SAFE;
121+
ALTERFUNCTION isnge(ismn13, ean13) PARALLEL SAFE;
122+
ALTERFUNCTION isngt(ismn13, ean13) PARALLEL SAFE;
123+
ALTERFUNCTION isnne(ismn13, ean13) PARALLEL SAFE;
124+
ALTERFUNCTION isnlt(ismn, ismn) PARALLEL SAFE;
125+
ALTERFUNCTION isnle(ismn, ismn) PARALLEL SAFE;
126+
ALTERFUNCTION isneq(ismn, ismn) PARALLEL SAFE;
127+
ALTERFUNCTION isnge(ismn, ismn) PARALLEL SAFE;
128+
ALTERFUNCTION isngt(ismn, ismn) PARALLEL SAFE;
129+
ALTERFUNCTION isnne(ismn, ismn) PARALLEL SAFE;
130+
ALTERFUNCTION isnlt(ismn, ismn13) PARALLEL SAFE;
131+
ALTERFUNCTION isnle(ismn, ismn13) PARALLEL SAFE;
132+
ALTERFUNCTION isneq(ismn, ismn13) PARALLEL SAFE;
133+
ALTERFUNCTION isnge(ismn, ismn13) PARALLEL SAFE;
134+
ALTERFUNCTION isngt(ismn, ismn13) PARALLEL SAFE;
135+
ALTERFUNCTION isnne(ismn, ismn13) PARALLEL SAFE;
136+
ALTERFUNCTION isnlt(ismn, ean13) PARALLEL SAFE;
137+
ALTERFUNCTION isnle(ismn, ean13) PARALLEL SAFE;
138+
ALTERFUNCTION isneq(ismn, ean13) PARALLEL SAFE;
139+
ALTERFUNCTION isnge(ismn, ean13) PARALLEL SAFE;
140+
ALTERFUNCTION isngt(ismn, ean13) PARALLEL SAFE;
141+
ALTERFUNCTION isnne(ismn, ean13) PARALLEL SAFE;
142+
ALTERFUNCTION isnlt(issn13, issn13) PARALLEL SAFE;
143+
ALTERFUNCTION isnle(issn13, issn13) PARALLEL SAFE;
144+
ALTERFUNCTION isneq(issn13, issn13) PARALLEL SAFE;
145+
ALTERFUNCTION isnge(issn13, issn13) PARALLEL SAFE;
146+
ALTERFUNCTION isngt(issn13, issn13) PARALLEL SAFE;
147+
ALTERFUNCTION isnne(issn13, issn13) PARALLEL SAFE;
148+
ALTERFUNCTION isnlt(issn13, issn) PARALLEL SAFE;
149+
ALTERFUNCTION isnle(issn13, issn) PARALLEL SAFE;
150+
ALTERFUNCTION isneq(issn13, issn) PARALLEL SAFE;
151+
ALTERFUNCTION isnge(issn13, issn) PARALLEL SAFE;
152+
ALTERFUNCTION isngt(issn13, issn) PARALLEL SAFE;
153+
ALTERFUNCTION isnne(issn13, issn) PARALLEL SAFE;
154+
ALTERFUNCTION isnlt(issn13, ean13) PARALLEL SAFE;
155+
ALTERFUNCTION isnle(issn13, ean13) PARALLEL SAFE;
156+
ALTERFUNCTION isneq(issn13, ean13) PARALLEL SAFE;
157+
ALTERFUNCTION isnge(issn13, ean13) PARALLEL SAFE;
158+
ALTERFUNCTION isngt(issn13, ean13) PARALLEL SAFE;
159+
ALTERFUNCTION isnne(issn13, ean13) PARALLEL SAFE;
160+
ALTERFUNCTION isnlt(issn, issn) PARALLEL SAFE;
161+
ALTERFUNCTION isnle(issn, issn) PARALLEL SAFE;
162+
ALTERFUNCTION isneq(issn, issn) PARALLEL SAFE;
163+
ALTERFUNCTION isnge(issn, issn) PARALLEL SAFE;
164+
ALTERFUNCTION isngt(issn, issn) PARALLEL SAFE;
165+
ALTERFUNCTION isnne(issn, issn) PARALLEL SAFE;
166+
ALTERFUNCTION isnlt(issn, issn13) PARALLEL SAFE;
167+
ALTERFUNCTION isnle(issn, issn13) PARALLEL SAFE;
168+
ALTERFUNCTION isneq(issn, issn13) PARALLEL SAFE;
169+
ALTERFUNCTION isnge(issn, issn13) PARALLEL SAFE;
170+
ALTERFUNCTION isngt(issn, issn13) PARALLEL SAFE;
171+
ALTERFUNCTION isnne(issn, issn13) PARALLEL SAFE;
172+
ALTERFUNCTION isnlt(issn, ean13) PARALLEL SAFE;
173+
ALTERFUNCTION isnle(issn, ean13) PARALLEL SAFE;
174+
ALTERFUNCTION isneq(issn, ean13) PARALLEL SAFE;
175+
ALTERFUNCTION isnge(issn, ean13) PARALLEL SAFE;
176+
ALTERFUNCTION isngt(issn, ean13) PARALLEL SAFE;
177+
ALTERFUNCTION isnne(issn, ean13) PARALLEL SAFE;
178+
ALTERFUNCTION isnlt(upc, upc) PARALLEL SAFE;
179+
ALTERFUNCTION isnle(upc, upc) PARALLEL SAFE;
180+
ALTERFUNCTION isneq(upc, upc) PARALLEL SAFE;
181+
ALTERFUNCTION isnge(upc, upc) PARALLEL SAFE;
182+
ALTERFUNCTION isngt(upc, upc) PARALLEL SAFE;
183+
ALTERFUNCTION isnne(upc, upc) PARALLEL SAFE;
184+
ALTERFUNCTION isnlt(upc, ean13) PARALLEL SAFE;
185+
ALTERFUNCTION isnle(upc, ean13) PARALLEL SAFE;
186+
ALTERFUNCTION isneq(upc, ean13) PARALLEL SAFE;
187+
ALTERFUNCTION isnge(upc, ean13) PARALLEL SAFE;
188+
ALTERFUNCTION isngt(upc, ean13) PARALLEL SAFE;
189+
ALTERFUNCTION isnne(upc, ean13) PARALLEL SAFE;
190+
ALTERFUNCTION btean13cmp(ean13, ean13) PARALLEL SAFE;
191+
ALTERFUNCTION hashean13(ean13) PARALLEL SAFE;
192+
ALTERFUNCTION btean13cmp(ean13, isbn13) PARALLEL SAFE;
193+
ALTERFUNCTION btean13cmp(ean13, ismn13) PARALLEL SAFE;
194+
ALTERFUNCTION btean13cmp(ean13, issn13) PARALLEL SAFE;
195+
ALTERFUNCTION btean13cmp(ean13, isbn) PARALLEL SAFE;
196+
ALTERFUNCTION btean13cmp(ean13, ismn) PARALLEL SAFE;
197+
ALTERFUNCTION btean13cmp(ean13, issn) PARALLEL SAFE;
198+
ALTERFUNCTION btean13cmp(ean13, upc) PARALLEL SAFE;
199+
ALTERFUNCTION btisbn13cmp(isbn13, isbn13) PARALLEL SAFE;
200+
ALTERFUNCTION hashisbn13(isbn13) PARALLEL SAFE;
201+
ALTERFUNCTION btisbn13cmp(isbn13, ean13) PARALLEL SAFE;
202+
ALTERFUNCTION btisbn13cmp(isbn13, isbn) PARALLEL SAFE;
203+
ALTERFUNCTION btisbncmp(isbn, isbn) PARALLEL SAFE;
204+
ALTERFUNCTION hashisbn(isbn) PARALLEL SAFE;
205+
ALTERFUNCTION btisbncmp(isbn, ean13) PARALLEL SAFE;
206+
ALTERFUNCTION btisbncmp(isbn, isbn13) PARALLEL SAFE;
207+
ALTERFUNCTION btismn13cmp(ismn13, ismn13) PARALLEL SAFE;
208+
ALTERFUNCTION hashismn13(ismn13) PARALLEL SAFE;
209+
ALTERFUNCTION btismn13cmp(ismn13, ean13) PARALLEL SAFE;
210+
ALTERFUNCTION btismn13cmp(ismn13, ismn) PARALLEL SAFE;
211+
ALTERFUNCTION btismncmp(ismn, ismn) PARALLEL SAFE;
212+
ALTERFUNCTION hashismn(ismn) PARALLEL SAFE;
213+
ALTERFUNCTION btismncmp(ismn, ean13) PARALLEL SAFE;
214+
ALTERFUNCTION btismncmp(ismn, ismn13) PARALLEL SAFE;
215+
ALTERFUNCTION btissn13cmp(issn13, issn13) PARALLEL SAFE;
216+
ALTERFUNCTION hashissn13(issn13) PARALLEL SAFE;
217+
ALTERFUNCTION btissn13cmp(issn13, ean13) PARALLEL SAFE;
218+
ALTERFUNCTION btissn13cmp(issn13, issn) PARALLEL SAFE;
219+
ALTERFUNCTION btissncmp(issn, issn) PARALLEL SAFE;
220+
ALTERFUNCTION hashissn(issn) PARALLEL SAFE;
221+
ALTERFUNCTION btissncmp(issn, ean13) PARALLEL SAFE;
222+
ALTERFUNCTION btissncmp(issn, issn13) PARALLEL SAFE;
223+
ALTERFUNCTION btupccmp(upc, upc) PARALLEL SAFE;
224+
ALTERFUNCTION hashupc(upc) PARALLEL SAFE;
225+
ALTERFUNCTION btupccmp(upc, ean13) PARALLEL SAFE;
226+
ALTERFUNCTION isbn13(ean13) PARALLEL SAFE;
227+
ALTERFUNCTION ismn13(ean13) PARALLEL SAFE;
228+
ALTERFUNCTION issn13(ean13) PARALLEL SAFE;
229+
ALTERFUNCTION isbn(ean13) PARALLEL SAFE;
230+
ALTERFUNCTION ismn(ean13) PARALLEL SAFE;
231+
ALTERFUNCTION issn(ean13) PARALLEL SAFE;
232+
ALTERFUNCTION upc(ean13) PARALLEL SAFE;
233+
ALTERFUNCTION make_valid(ean13) PARALLEL SAFE;
234+
ALTERFUNCTION make_valid(isbn13) PARALLEL SAFE;
235+
ALTERFUNCTION make_valid(ismn13) PARALLEL SAFE;
236+
ALTERFUNCTION make_valid(issn13) PARALLEL SAFE;
237+
ALTERFUNCTION make_valid(isbn) PARALLEL SAFE;
238+
ALTERFUNCTION make_valid(ismn) PARALLEL SAFE;
239+
ALTERFUNCTION make_valid(issn) PARALLEL SAFE;
240+
ALTERFUNCTION make_valid(upc) PARALLEL SAFE;
241+
ALTERFUNCTION is_valid(ean13) PARALLEL SAFE;
242+
ALTERFUNCTION is_valid(isbn13) PARALLEL SAFE;
243+
ALTERFUNCTION is_valid(ismn13) PARALLEL SAFE;
244+
ALTERFUNCTION is_valid(issn13) PARALLEL SAFE;
245+
ALTERFUNCTION is_valid(isbn) PARALLEL SAFE;
246+
ALTERFUNCTION is_valid(ismn) PARALLEL SAFE;
247+
ALTERFUNCTION is_valid(issn) PARALLEL SAFE;
248+
ALTERFUNCTION is_valid(upc) PARALLEL SAFE;
249+
ALTERFUNCTION isn_weak(boolean) PARALLEL RESTRICTED;
250+
ALTERFUNCTION isn_weak() PARALLEL RESTRICTED;

0 commit comments

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