1 /* contrib/isn/isn--1.1--1.2.sql */
3 -- complain if script is sourced in psql, rather than via ALTER EXTENSION
4 \echo Use "ALTER EXTENSION isn UPDATE TO '1.2'" to load this file. \quit
6 ALTER OPERATOR <= (ean13, ean13) SET (
7 RESTRICT = scalarlesel,
8 JOIN = scalarlejoinsel);
10 ALTER OPERATOR >= (ean13, ean13) SET (
11 RESTRICT = scalargesel,
12 JOIN = scalargejoinsel);
14 ALTER OPERATOR <= (ean13, isbn13) SET (
15 RESTRICT = scalarlesel,
16 JOIN = scalarlejoinsel);
18 ALTER OPERATOR >= (ean13, isbn13) SET (
19 RESTRICT = scalargesel,
20 JOIN = scalargejoinsel);
22 ALTER OPERATOR <= (isbn13, ean13) SET (
23 RESTRICT = scalarlesel,
24 JOIN = scalarlejoinsel);
26 ALTER OPERATOR >= (isbn13, ean13) SET (
27 RESTRICT = scalargesel,
28 JOIN = scalargejoinsel);
30 ALTER OPERATOR <= (ean13, ismn13) SET (
31 RESTRICT = scalarlesel,
32 JOIN = scalarlejoinsel);
34 ALTER OPERATOR >= (ean13, ismn13) SET (
35 RESTRICT = scalargesel,
36 JOIN = scalargejoinsel);
38 ALTER OPERATOR <= (ismn13, ean13) SET (
39 RESTRICT = scalarlesel,
40 JOIN = scalarlejoinsel);
42 ALTER OPERATOR >= (ismn13, ean13) SET (
43 RESTRICT = scalargesel,
44 JOIN = scalargejoinsel);
46 ALTER OPERATOR <= (ean13, issn13) SET (
47 RESTRICT = scalarlesel,
48 JOIN = scalarlejoinsel);
50 ALTER OPERATOR >= (ean13, issn13) SET (
51 RESTRICT = scalargesel,
52 JOIN = scalargejoinsel);
54 ALTER OPERATOR <= (ean13, isbn) SET (
55 RESTRICT = scalarlesel,
56 JOIN = scalarlejoinsel);
58 ALTER OPERATOR >= (ean13, isbn) SET (
59 RESTRICT = scalargesel,
60 JOIN = scalargejoinsel);
62 ALTER OPERATOR <= (ean13, ismn) SET (
63 RESTRICT = scalarlesel,
64 JOIN = scalarlejoinsel);
66 ALTER OPERATOR >= (ean13, ismn) SET (
67 RESTRICT = scalargesel,
68 JOIN = scalargejoinsel);
70 ALTER OPERATOR <= (ean13, issn) SET (
71 RESTRICT = scalarlesel,
72 JOIN = scalarlejoinsel);
74 ALTER OPERATOR >= (ean13, issn) SET (
75 RESTRICT = scalargesel,
76 JOIN = scalargejoinsel);
78 ALTER OPERATOR <= (ean13, upc) SET (
79 RESTRICT = scalarlesel,
80 JOIN = scalarlejoinsel);
82 ALTER OPERATOR >= (ean13, upc) SET (
83 RESTRICT = scalargesel,
84 JOIN = scalargejoinsel);
86 ALTER OPERATOR <= (isbn13, isbn13) SET (
87 RESTRICT = scalarlesel,
88 JOIN = scalarlejoinsel);
90 ALTER OPERATOR >= (isbn13, isbn13) SET (
91 RESTRICT = scalargesel,
92 JOIN = scalargejoinsel);
94 ALTER OPERATOR <= (isbn13, isbn) SET (
95 RESTRICT = scalarlesel,
96 JOIN = scalarlejoinsel);
98 ALTER OPERATOR >= (isbn13, isbn) SET (
99 RESTRICT = scalargesel,
100 JOIN = scalargejoinsel);
102 ALTER OPERATOR <= (isbn, isbn) SET (
103 RESTRICT = scalarlesel,
104 JOIN = scalarlejoinsel);
106 ALTER OPERATOR >= (isbn, isbn) SET (
107 RESTRICT = scalargesel,
108 JOIN = scalargejoinsel);
110 ALTER OPERATOR <= (isbn, isbn13) SET (
111 RESTRICT = scalarlesel,
112 JOIN = scalarlejoinsel);
114 ALTER OPERATOR >= (isbn, isbn13) SET (
115 RESTRICT = scalargesel,
116 JOIN = scalargejoinsel);
118 ALTER OPERATOR <= (isbn, ean13) SET (
119 RESTRICT = scalarlesel,
120 JOIN = scalarlejoinsel);
122 ALTER OPERATOR >= (isbn, ean13) SET (
123 RESTRICT = scalargesel,
124 JOIN = scalargejoinsel);
126 ALTER OPERATOR <= (ismn13, ismn13) SET (
127 RESTRICT = scalarlesel,
128 JOIN = scalarlejoinsel);
130 ALTER OPERATOR >= (ismn13, ismn13) SET (
131 RESTRICT = scalargesel,
132 JOIN = scalargejoinsel);
134 ALTER OPERATOR <= (ismn13, ismn) SET (
135 RESTRICT = scalarlesel,
136 JOIN = scalarlejoinsel);
138 ALTER OPERATOR >= (ismn13, ismn) SET (
139 RESTRICT = scalargesel,
140 JOIN = scalargejoinsel);
142 ALTER OPERATOR <= (ismn, ismn) SET (
143 RESTRICT = scalarlesel,
144 JOIN = scalarlejoinsel);
146 ALTER OPERATOR >= (ismn, ismn) SET (
147 RESTRICT = scalargesel,
148 JOIN = scalargejoinsel);
150 ALTER OPERATOR <= (ismn, ismn13) SET (
151 RESTRICT = scalarlesel,
152 JOIN = scalarlejoinsel);
154 ALTER OPERATOR >= (ismn, ismn13) SET (
155 RESTRICT = scalargesel,
156 JOIN = scalargejoinsel);
158 ALTER OPERATOR <= (ismn, ean13) SET (
159 RESTRICT = scalarlesel,
160 JOIN = scalarlejoinsel);
162 ALTER OPERATOR >= (ismn, ean13) SET (
163 RESTRICT = scalargesel,
164 JOIN = scalargejoinsel);
166 ALTER OPERATOR <= (issn13, issn13) SET (
167 RESTRICT = scalarlesel,
168 JOIN = scalarlejoinsel);
170 ALTER OPERATOR >= (issn13, issn13) SET (
171 RESTRICT = scalargesel,
172 JOIN = scalargejoinsel);
174 ALTER OPERATOR <= (issn13, issn) SET (
175 RESTRICT = scalarlesel,
176 JOIN = scalarlejoinsel);
178 ALTER OPERATOR >= (issn13, issn) SET (
179 RESTRICT = scalargesel,
180 JOIN = scalargejoinsel);
182 ALTER OPERATOR <= (issn13, ean13) SET (
183 RESTRICT = scalarlesel,
184 JOIN = scalarlejoinsel);
186 ALTER OPERATOR >= (issn13, ean13) SET (
187 RESTRICT = scalargesel,
188 JOIN = scalargejoinsel);
190 ALTER OPERATOR <= (issn, issn) SET (
191 RESTRICT = scalarlesel,
192 JOIN = scalarlejoinsel);
194 ALTER OPERATOR >= (issn, issn) SET (
195 RESTRICT = scalargesel,
196 JOIN = scalargejoinsel);
198 ALTER OPERATOR <= (issn, issn13) SET (
199 RESTRICT = scalarlesel,
200 JOIN = scalarlejoinsel);
202 ALTER OPERATOR >= (issn, issn13) SET (
203 RESTRICT = scalargesel,
204 JOIN = scalargejoinsel);
206 ALTER OPERATOR <= (issn, ean13) SET (
207 RESTRICT = scalarlesel,
208 JOIN = scalarlejoinsel);
210 ALTER OPERATOR >= (issn, ean13) SET (
211 RESTRICT = scalargesel,
212 JOIN = scalargejoinsel);
214 ALTER OPERATOR <= (upc, upc) SET (
215 RESTRICT = scalarlesel,
216 JOIN = scalarlejoinsel);
218 ALTER OPERATOR >= (upc, upc) SET (
219 RESTRICT = scalargesel,
220 JOIN = scalargejoinsel);
222 ALTER OPERATOR <= (upc, ean13) SET (
223 RESTRICT = scalarlesel,
224 JOIN = scalarlejoinsel);
226 ALTER OPERATOR >= (upc, ean13) SET (
227 RESTRICT = scalargesel,
228 JOIN = scalargejoinsel);