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