ip4r-2.4.1/scripts/ip4r--unpackaged2.1--2.1.sql

6 ALTER EXTENSION ip4r ADD FUNCTION ip4_in(cstring);
7 ALTER EXTENSION ip4r ADD FUNCTION ip4_out(ip4);
8 ALTER EXTENSION ip4r ADD FUNCTION ip4_recv(internal);
9 ALTER EXTENSION ip4r ADD FUNCTION ip4_send(ip4);
10 ALTER EXTENSION ip4r ADD TYPE ip4;
11 ALTER EXTENSION ip4r ADD FUNCTION ip4r_in(cstring);
12 ALTER EXTENSION ip4r ADD FUNCTION ip4r_out(ip4r);
13 ALTER EXTENSION ip4r ADD FUNCTION ip4r_recv(internal);
14 ALTER EXTENSION ip4r ADD FUNCTION ip4r_send(ip4r);
15 ALTER EXTENSION ip4r ADD TYPE ip4r;
16 ALTER EXTENSION ip4r ADD FUNCTION ip6_in(cstring);
17 ALTER EXTENSION ip4r ADD FUNCTION ip6_out(ip6);
18 ALTER EXTENSION ip4r ADD FUNCTION ip6_recv(internal);
19 ALTER EXTENSION ip4r ADD FUNCTION ip6_send(ip6);
20 ALTER EXTENSION ip4r ADD TYPE ip6;
21 ALTER EXTENSION ip4r ADD FUNCTION ip6r_in(cstring);
22 ALTER EXTENSION ip4r ADD FUNCTION ip6r_out(ip6r);
23 ALTER EXTENSION ip4r ADD FUNCTION ip6r_recv(internal);
24 ALTER EXTENSION ip4r ADD FUNCTION ip6r_send(ip6r);
25 ALTER EXTENSION ip4r ADD TYPE ip6r;
26 ALTER EXTENSION ip4r ADD FUNCTION ipaddress_in(cstring);
27 ALTER EXTENSION ip4r ADD FUNCTION ipaddress_out(ipaddress);
28 ALTER EXTENSION ip4r ADD FUNCTION ipaddress_recv(internal);
29 ALTER EXTENSION ip4r ADD FUNCTION ipaddress_send(ipaddress);
30 ALTER EXTENSION ip4r ADD TYPE ipaddress;
31 ALTER EXTENSION ip4r ADD FUNCTION iprange_in(cstring);
32 ALTER EXTENSION ip4r ADD FUNCTION iprange_out(iprange);
33 ALTER EXTENSION ip4r ADD FUNCTION iprange_recv(internal);
34 ALTER EXTENSION ip4r ADD FUNCTION iprange_send(iprange);
35 ALTER EXTENSION ip4r ADD TYPE iprange;
36 ALTER EXTENSION ip4r ADD FUNCTION ip4(bigint);
37 ALTER EXTENSION ip4r ADD FUNCTION ip4(double precision);
38 ALTER EXTENSION ip4r ADD FUNCTION ip4(numeric);
39 ALTER EXTENSION ip4r ADD FUNCTION ip4(inet);
40 ALTER EXTENSION ip4r ADD FUNCTION ip4(text);
41 ALTER EXTENSION ip4r ADD FUNCTION ip4(ipaddress);
42 ALTER EXTENSION ip4r ADD FUNCTION ip6(numeric);
43 ALTER EXTENSION ip4r ADD FUNCTION ip6(inet);
44 ALTER EXTENSION ip4r ADD FUNCTION ip6(text);
45 ALTER EXTENSION ip4r ADD FUNCTION ip6(ipaddress);
46 ALTER EXTENSION ip4r ADD FUNCTION ipaddress(inet);
47 ALTER EXTENSION ip4r ADD FUNCTION ipaddress(ip4);
48 ALTER EXTENSION ip4r ADD FUNCTION ipaddress(ip6);
49 ALTER EXTENSION ip4r ADD FUNCTION ipaddress(text);
50 ALTER EXTENSION ip4r ADD FUNCTION ip4r(cidr);
51 ALTER EXTENSION ip4r ADD FUNCTION ip4r(ip4);
52 ALTER EXTENSION ip4r ADD FUNCTION ip4r(text);
53 ALTER EXTENSION ip4r ADD FUNCTION ip4r(iprange);
54 ALTER EXTENSION ip4r ADD FUNCTION ip6r(cidr);
55 ALTER EXTENSION ip4r ADD FUNCTION ip6r(ip6);
56 ALTER EXTENSION ip4r ADD FUNCTION ip6r(text);
57 ALTER EXTENSION ip4r ADD FUNCTION ip6r(iprange);
58 ALTER EXTENSION ip4r ADD FUNCTION iprange(cidr);
59 ALTER EXTENSION ip4r ADD FUNCTION iprange(ip4);
60 ALTER EXTENSION ip4r ADD FUNCTION iprange(ip6);
61 ALTER EXTENSION ip4r ADD FUNCTION iprange(ip4r);
62 ALTER EXTENSION ip4r ADD FUNCTION iprange(ip6r);
63 ALTER EXTENSION ip4r ADD FUNCTION iprange(ipaddress);
64 ALTER EXTENSION ip4r ADD FUNCTION iprange(text);
65 ALTER EXTENSION ip4r ADD FUNCTION cidr(ip4);
66 ALTER EXTENSION ip4r ADD FUNCTION cidr(ip4r);
67 ALTER EXTENSION ip4r ADD FUNCTION cidr(ip6);
68 ALTER EXTENSION ip4r ADD FUNCTION cidr(ip6r);
69 ALTER EXTENSION ip4r ADD FUNCTION cidr(ipaddress);
70 ALTER EXTENSION ip4r ADD FUNCTION cidr(iprange);
71 ALTER EXTENSION ip4r ADD FUNCTION text(ip4);
72 ALTER EXTENSION ip4r ADD FUNCTION text(ip4r);
73 ALTER EXTENSION ip4r ADD FUNCTION text(ip6);
74 ALTER EXTENSION ip4r ADD FUNCTION text(ip6r);
75 ALTER EXTENSION ip4r ADD FUNCTION text(ipaddress);
76 ALTER EXTENSION ip4r ADD FUNCTION text(iprange);
77 ALTER EXTENSION ip4r ADD FUNCTION to_bigint(ip4);
78 ALTER EXTENSION ip4r ADD FUNCTION to_double(ip4);
79 ALTER EXTENSION ip4r ADD FUNCTION to_numeric(ip4);
80 ALTER EXTENSION ip4r ADD FUNCTION to_numeric(ip6);
81 ALTER EXTENSION ip4r ADD FUNCTION to_numeric(ipaddress);
82 ALTER EXTENSION ip4r ADD CAST (ip4 as bigint);
83 ALTER EXTENSION ip4r ADD CAST (ip4 as double precision);
84 ALTER EXTENSION ip4r ADD CAST (ip4 as numeric);
85 ALTER EXTENSION ip4r ADD CAST (ip4 as text);
86 ALTER EXTENSION ip4r ADD CAST (ip4 as cidr);
87 ALTER EXTENSION ip4r ADD CAST (ip4r as cidr);
88 ALTER EXTENSION ip4r ADD CAST (ip4r as text);
89 ALTER EXTENSION ip4r ADD CAST (ip6 as numeric);
90 ALTER EXTENSION ip4r ADD CAST (ip6 as text);
91 ALTER EXTENSION ip4r ADD CAST (ip6 as cidr);
92 ALTER EXTENSION ip4r ADD CAST (ip6r as cidr);
93 ALTER EXTENSION ip4r ADD CAST (ip6r as text);
94 ALTER EXTENSION ip4r ADD CAST (ipaddress as numeric);
95 ALTER EXTENSION ip4r ADD CAST (ipaddress as text);
96 ALTER EXTENSION ip4r ADD CAST (ipaddress as cidr);
97 ALTER EXTENSION ip4r ADD CAST (iprange as cidr);
98 ALTER EXTENSION ip4r ADD CAST (iprange as text);
99 ALTER EXTENSION ip4r ADD CAST (text as ip4);
100 ALTER EXTENSION ip4r ADD CAST (text as ip4r);
101 ALTER EXTENSION ip4r ADD CAST (text as ip6);
102 ALTER EXTENSION ip4r ADD CAST (text as ip6r);
103 ALTER EXTENSION ip4r ADD CAST (text as ipaddress);
104 ALTER EXTENSION ip4r ADD CAST (text as iprange);
105 ALTER EXTENSION ip4r ADD CAST (bigint as ip4);
106 ALTER EXTENSION ip4r ADD CAST (double precision as ip4);
107 ALTER EXTENSION ip4r ADD CAST (numeric as ip4);
108 ALTER EXTENSION ip4r ADD CAST (numeric as ip6);
109 ALTER EXTENSION ip4r ADD CAST (cidr as ip4r);
110 ALTER EXTENSION ip4r ADD CAST (cidr as ip6r);
111 ALTER EXTENSION ip4r ADD CAST (cidr as iprange);
112 ALTER EXTENSION ip4r ADD CAST (inet as ip4);
113 ALTER EXTENSION ip4r ADD CAST (inet as ip6);
114 ALTER EXTENSION ip4r ADD CAST (inet as ipaddress);
115 ALTER EXTENSION ip4r ADD CAST (ip4 as ip4r);
116 ALTER EXTENSION ip4r ADD CAST (ip4 as ipaddress);
117 ALTER EXTENSION ip4r ADD CAST (ip4 as iprange);
118 ALTER EXTENSION ip4r ADD CAST (ip4r as iprange);
119 ALTER EXTENSION ip4r ADD CAST (ip6 as ip6r);
120 ALTER EXTENSION ip4r ADD CAST (ip6 as ipaddress);
121 ALTER EXTENSION ip4r ADD CAST (ip6 as iprange);
122 ALTER EXTENSION ip4r ADD CAST (ip6r as iprange);
123 ALTER EXTENSION ip4r ADD CAST (ipaddress as iprange);
124 ALTER EXTENSION ip4r ADD CAST (ipaddress as ip4);
125 ALTER EXTENSION ip4r ADD CAST (ipaddress as ip6);
126 ALTER EXTENSION ip4r ADD CAST (iprange as ip4r);
127 ALTER EXTENSION ip4r ADD CAST (iprange as ip6r);
128 ALTER EXTENSION ip4r ADD FUNCTION ip4r(ip4,ip4);
129 ALTER EXTENSION ip4r ADD FUNCTION ip6r(ip6,ip6);
130 ALTER EXTENSION ip4r ADD FUNCTION iprange(ip4,ip4);
131 ALTER EXTENSION ip4r ADD FUNCTION iprange(ip6,ip6);
132 ALTER EXTENSION ip4r ADD FUNCTION iprange(ipaddress,ipaddress);
133 ALTER EXTENSION ip4r ADD FUNCTION family(ip4);
134 ALTER EXTENSION ip4r ADD FUNCTION family(ip4r);
135 ALTER EXTENSION ip4r ADD FUNCTION family(ip6);
136 ALTER EXTENSION ip4r ADD FUNCTION family(ip6r);
137 ALTER EXTENSION ip4r ADD FUNCTION family(ipaddress);
138 ALTER EXTENSION ip4r ADD FUNCTION family(iprange);
139 ALTER EXTENSION ip4r ADD FUNCTION ip4_netmask(integer);
140 ALTER EXTENSION ip4r ADD FUNCTION ip6_netmask(integer);
141 ALTER EXTENSION ip4r ADD FUNCTION is_cidr(ip4r);
142 ALTER EXTENSION ip4r ADD FUNCTION is_cidr(ip6r);
143 ALTER EXTENSION ip4r ADD FUNCTION is_cidr(iprange);
144 ALTER EXTENSION ip4r ADD FUNCTION masklen(ip4r);
145 ALTER EXTENSION ip4r ADD FUNCTION masklen(ip6r);
146 ALTER EXTENSION ip4r ADD FUNCTION masklen(iprange);
147 ALTER EXTENSION ip4r ADD FUNCTION lower(ip4r);
148 ALTER EXTENSION ip4r ADD FUNCTION lower(ip6r);
149 ALTER EXTENSION ip4r ADD FUNCTION lower(iprange);
150 ALTER EXTENSION ip4r ADD FUNCTION upper(ip4r);
151 ALTER EXTENSION ip4r ADD FUNCTION upper(ip6r);
152 ALTER EXTENSION ip4r ADD FUNCTION upper(iprange);
153 ALTER EXTENSION ip4r ADD FUNCTION ip4_net_lower(ip4,integer);
154 ALTER EXTENSION ip4r ADD FUNCTION ip6_net_lower(ip6,integer);
155 ALTER EXTENSION ip4r ADD FUNCTION ipaddress_net_lower(ipaddress,integer);
156 ALTER EXTENSION ip4r ADD FUNCTION ip4_net_upper(ip4,integer);
157 ALTER EXTENSION ip4r ADD FUNCTION ip6_net_upper(ip6,integer);
158 ALTER EXTENSION ip4r ADD FUNCTION ipaddress_net_upper(ipaddress,integer);
159 ALTER EXTENSION ip4r ADD FUNCTION ip4r_union(ip4r, ip4r);
160 ALTER EXTENSION ip4r ADD FUNCTION ip6r_union(ip6r, ip6r);
161 ALTER EXTENSION ip4r ADD FUNCTION iprange_union(iprange, iprange);
162 ALTER EXTENSION ip4r ADD FUNCTION ip4r_inter(ip4r,ip4r);
163 ALTER EXTENSION ip4r ADD FUNCTION ip6r_inter(ip6r,ip6r);
164 ALTER EXTENSION ip4r ADD FUNCTION iprange_inter(iprange,iprange);
165 ALTER EXTENSION ip4r ADD FUNCTION ip4r_net_mask(ip4,ip4);
166 ALTER EXTENSION ip4r ADD FUNCTION ip6r_net_mask(ip6,ip6);
167 ALTER EXTENSION ip4r ADD FUNCTION iprange_net_mask(ip4,ip4);
168 ALTER EXTENSION ip4r ADD FUNCTION iprange_net_mask(ip6,ip6);
169 ALTER EXTENSION ip4r ADD FUNCTION iprange_net_mask(ipaddress,ipaddress);
170 ALTER EXTENSION ip4r ADD FUNCTION ip4r_net_prefix(ip4,integer);
171 ALTER EXTENSION ip4r ADD FUNCTION ip6r_net_prefix(ip6,integer);
172 ALTER EXTENSION ip4r ADD FUNCTION iprange_net_prefix(ip4,integer);
173 ALTER EXTENSION ip4r ADD FUNCTION iprange_net_prefix(ip6,integer);
174 ALTER EXTENSION ip4r ADD FUNCTION iprange_net_prefix(ipaddress,integer);
175 ALTER EXTENSION ip4r ADD OPERATOR /(ip4,ip4);
176 ALTER EXTENSION ip4r ADD OPERATOR /(ip6,ip6);
177 ALTER EXTENSION ip4r ADD OPERATOR /(ipaddress,ipaddress);
178 ALTER EXTENSION ip4r ADD OPERATOR /(ip4,integer);
179 ALTER EXTENSION ip4r ADD OPERATOR /(ip6,integer);
180 ALTER EXTENSION ip4r ADD OPERATOR /(ipaddress,integer);
181 ALTER EXTENSION ip4r ADD FUNCTION ip4r_size(ip4r);
182 ALTER EXTENSION ip4r ADD FUNCTION ip6r_size(ip6r);
183 ALTER EXTENSION ip4r ADD FUNCTION iprange_size(iprange);
184 ALTER EXTENSION ip4r ADD FUNCTION ip4r_size_exact(ip4r);
185 ALTER EXTENSION ip4r ADD FUNCTION ip6r_size_exact(ip6r);
186 ALTER EXTENSION ip4r ADD FUNCTION iprange_size_exact(iprange);
187 ALTER EXTENSION ip4r ADD OPERATOR @(NONE,ip4r);
188 ALTER EXTENSION ip4r ADD OPERATOR @(NONE,ip6r);
189 ALTER EXTENSION ip4r ADD OPERATOR @(NONE,iprange);
190 ALTER EXTENSION ip4r ADD OPERATOR @@(NONE,ip4r);
191 ALTER EXTENSION ip4r ADD OPERATOR @@(NONE,ip6r);
192 ALTER EXTENSION ip4r ADD OPERATOR @@(NONE,iprange);
193 ALTER EXTENSION ip4r ADD FUNCTION ip4_and(ip4,ip4);
194 ALTER EXTENSION ip4r ADD FUNCTION ip6_and(ip6,ip6);
195 ALTER EXTENSION ip4r ADD FUNCTION ipaddress_and(ipaddress,ipaddress);
196 ALTER EXTENSION ip4r ADD OPERATOR &(ip4,ip4);
197 ALTER EXTENSION ip4r ADD OPERATOR &(ip6,ip6);
198 ALTER EXTENSION ip4r ADD OPERATOR &(ipaddress,ipaddress);
199 ALTER EXTENSION ip4r ADD FUNCTION ip4_or(ip4,ip4);
200 ALTER EXTENSION ip4r ADD FUNCTION ip6_or(ip6,ip6);
201 ALTER EXTENSION ip4r ADD FUNCTION ipaddress_or(ipaddress,ipaddress);
202 ALTER EXTENSION ip4r ADD OPERATOR |(ip4,ip4);
203 ALTER EXTENSION ip4r ADD OPERATOR |(ip6,ip6);
204 ALTER EXTENSION ip4r ADD OPERATOR |(ipaddress,ipaddress);
205 ALTER EXTENSION ip4r ADD FUNCTION ip4_not(ip4);
206 ALTER EXTENSION ip4r ADD FUNCTION ip6_not(ip6);
207 ALTER EXTENSION ip4r ADD FUNCTION ipaddress_not(ipaddress);
208 ALTER EXTENSION ip4r ADD OPERATOR ~(NONE,ip4);
209 ALTER EXTENSION ip4r ADD OPERATOR ~(NONE,ip6);
210 ALTER EXTENSION ip4r ADD OPERATOR ~(NONE,ipaddress);
211 ALTER EXTENSION ip4r ADD FUNCTION ip4_xor(ip4,ip4);
212 ALTER EXTENSION ip4r ADD FUNCTION ip6_xor(ip6,ip6);
213 ALTER EXTENSION ip4r ADD FUNCTION ipaddress_xor(ipaddress,ipaddress);
214 ALTER EXTENSION ip4r ADD OPERATOR #(ip4,ip4);
215 ALTER EXTENSION ip4r ADD OPERATOR #(ip6,ip6);
216 ALTER EXTENSION ip4r ADD OPERATOR #(ipaddress,ipaddress);
217 ALTER EXTENSION ip4r ADD FUNCTION ip4_plus_bigint(ip4,bigint);
218 ALTER EXTENSION ip4r ADD FUNCTION ip4_plus_int(ip4,integer);
219 ALTER EXTENSION ip4r ADD FUNCTION ip4_plus_numeric(ip4,numeric);
220 ALTER EXTENSION ip4r ADD OPERATOR +(ip4,bigint);
221 ALTER EXTENSION ip4r ADD OPERATOR +(ip4,integer);
222 ALTER EXTENSION ip4r ADD OPERATOR +(ip4,numeric);
223 ALTER EXTENSION ip4r ADD FUNCTION ip6_plus_bigint(ip6,bigint);
224 ALTER EXTENSION ip4r ADD FUNCTION ip6_plus_int(ip6,integer);
225 ALTER EXTENSION ip4r ADD FUNCTION ip6_plus_numeric(ip6,numeric);
226 ALTER EXTENSION ip4r ADD OPERATOR +(ip6,bigint);
227 ALTER EXTENSION ip4r ADD OPERATOR +(ip6,integer);
228 ALTER EXTENSION ip4r ADD OPERATOR +(ip6,numeric);
229 ALTER EXTENSION ip4r ADD FUNCTION ipaddress_plus_bigint(ipaddress,bigint);
230 ALTER EXTENSION ip4r ADD FUNCTION ipaddress_plus_int(ipaddress,integer);
231 ALTER EXTENSION ip4r ADD FUNCTION ipaddress_plus_numeric(ipaddress,numeric);
232 ALTER EXTENSION ip4r ADD OPERATOR +(ipaddress,bigint);
233 ALTER EXTENSION ip4r ADD OPERATOR +(ipaddress,integer);
234 ALTER EXTENSION ip4r ADD OPERATOR +(ipaddress,numeric);
235 ALTER EXTENSION ip4r ADD FUNCTION ip4_minus_bigint(ip4,bigint);
236 ALTER EXTENSION ip4r ADD FUNCTION ip4_minus_int(ip4,integer);
237 ALTER EXTENSION ip4r ADD FUNCTION ip4_minus_numeric(ip4,numeric);
238 ALTER EXTENSION ip4r ADD OPERATOR -(ip4,bigint);
239 ALTER EXTENSION ip4r ADD OPERATOR -(ip4,integer);
240 ALTER EXTENSION ip4r ADD OPERATOR -(ip4,numeric);
241 ALTER EXTENSION ip4r ADD FUNCTION ip6_minus_bigint(ip6,bigint);
242 ALTER EXTENSION ip4r ADD FUNCTION ip6_minus_int(ip6,integer);
243 ALTER EXTENSION ip4r ADD FUNCTION ip6_minus_numeric(ip6,numeric);
244 ALTER EXTENSION ip4r ADD OPERATOR -(ip6,bigint);
245 ALTER EXTENSION ip4r ADD OPERATOR -(ip6,integer);
246 ALTER EXTENSION ip4r ADD OPERATOR -(ip6,numeric);
247 ALTER EXTENSION ip4r ADD FUNCTION ipaddress_minus_bigint(ipaddress,bigint);
248 ALTER EXTENSION ip4r ADD FUNCTION ipaddress_minus_int(ipaddress,integer);
249 ALTER EXTENSION ip4r ADD FUNCTION ipaddress_minus_numeric(ipaddress,numeric);
250 ALTER EXTENSION ip4r ADD OPERATOR -(ipaddress,bigint);
251 ALTER EXTENSION ip4r ADD OPERATOR -(ipaddress,integer);
252 ALTER EXTENSION ip4r ADD OPERATOR -(ipaddress,numeric);
253 ALTER EXTENSION ip4r ADD FUNCTION ip4_minus_ip4(ip4,ip4);
254 ALTER EXTENSION ip4r ADD FUNCTION ip6_minus_ip6(ip6,ip6);
255 ALTER EXTENSION ip4r ADD FUNCTION ipaddress_minus_ipaddress(ipaddress,ipaddress);
256 ALTER EXTENSION ip4r ADD OPERATOR -(ip4,ip4);
257 ALTER EXTENSION ip4r ADD OPERATOR -(ip6,ip6);
258 ALTER EXTENSION ip4r ADD OPERATOR -(ipaddress,ipaddress);
259 ALTER EXTENSION ip4r ADD FUNCTION ip4r_contained_by(ip4r,ip4r);
260 ALTER EXTENSION ip4r ADD FUNCTION ip6r_contained_by(ip6r,ip6r);
261 ALTER EXTENSION ip4r ADD FUNCTION iprange_contained_by(iprange,iprange);
262 ALTER EXTENSION ip4r ADD OPERATOR <<=(ip4r,ip4r);
263 ALTER EXTENSION ip4r ADD OPERATOR <<=(ip6r,ip6r);
264 ALTER EXTENSION ip4r ADD OPERATOR <<=(iprange,iprange);
265 ALTER EXTENSION ip4r ADD FUNCTION ip4r_contained_by_strict(ip4r,ip4r);
266 ALTER EXTENSION ip4r ADD FUNCTION ip6r_contained_by_strict(ip6r,ip6r);
267 ALTER EXTENSION ip4r ADD FUNCTION iprange_contained_by_strict(iprange,iprange);
268 ALTER EXTENSION ip4r ADD OPERATOR <<(ip4r,ip4r);
269 ALTER EXTENSION ip4r ADD OPERATOR <<(ip6r,ip6r);
270 ALTER EXTENSION ip4r ADD OPERATOR <<(iprange,iprange);
271 ALTER EXTENSION ip4r ADD FUNCTION ip4r_contains(ip4r,ip4r);
272 ALTER EXTENSION ip4r ADD FUNCTION ip6r_contains(ip6r,ip6r);
273 ALTER EXTENSION ip4r ADD FUNCTION iprange_contains(iprange,iprange);
274 ALTER EXTENSION ip4r ADD OPERATOR >>=(ip4r,ip4r);
275 ALTER EXTENSION ip4r ADD OPERATOR >>=(ip6r,ip6r);
276 ALTER EXTENSION ip4r ADD OPERATOR >>=(iprange,iprange);
277 ALTER EXTENSION ip4r ADD FUNCTION ip4r_contains_strict(ip4r,ip4r);
278 ALTER EXTENSION ip4r ADD FUNCTION ip6r_contains_strict(ip6r,ip6r);
279 ALTER EXTENSION ip4r ADD FUNCTION iprange_contains_strict(iprange,iprange);
280 ALTER EXTENSION ip4r ADD OPERATOR >>(ip4r,ip4r);
281 ALTER EXTENSION ip4r ADD OPERATOR >>(ip6r,ip6r);
282 ALTER EXTENSION ip4r ADD OPERATOR >>(iprange,iprange);
283 ALTER EXTENSION ip4r ADD FUNCTION ip4r_overlaps(ip4r,ip4r);
284 ALTER EXTENSION ip4r ADD FUNCTION ip6r_overlaps(ip6r,ip6r);
285 ALTER EXTENSION ip4r ADD FUNCTION iprange_overlaps(iprange,iprange);
286 ALTER EXTENSION ip4r ADD OPERATOR &&(ip4r,ip4r);
287 ALTER EXTENSION ip4r ADD OPERATOR &&(ip6r,ip6r);
288 ALTER EXTENSION ip4r ADD OPERATOR &&(iprange,iprange);
289 ALTER EXTENSION ip4r ADD FUNCTION ip4_contained_by(ip4,ip4r);
290 ALTER EXTENSION ip4r ADD FUNCTION ip4_contained_by(ip4,iprange);
291 ALTER EXTENSION ip4r ADD FUNCTION ip6_contained_by(ip6,ip6r);
292 ALTER EXTENSION ip4r ADD FUNCTION ip6_contained_by(ip6,iprange);
293 ALTER EXTENSION ip4r ADD FUNCTION ipaddress_contained_by(ipaddress,iprange);
294 ALTER EXTENSION ip4r ADD FUNCTION ip4_contains(ip4r,ip4);
295 ALTER EXTENSION ip4r ADD FUNCTION ip6_contains(ip6r,ip6);
296 ALTER EXTENSION ip4r ADD FUNCTION ip4_contains(iprange,ip4);
297 ALTER EXTENSION ip4r ADD FUNCTION ip6_contains(iprange,ip6);
298 ALTER EXTENSION ip4r ADD FUNCTION ipaddress_contains(iprange,ipaddress);
299 ALTER EXTENSION ip4r ADD FUNCTION ip4_eq(ip4,ip4);
300 ALTER EXTENSION ip4r ADD FUNCTION ip4r_eq(ip4r,ip4r);
301 ALTER EXTENSION ip4r ADD FUNCTION ip6_eq(ip6,ip6);
302 ALTER EXTENSION ip4r ADD FUNCTION ip6r_eq(ip6r,ip6r);
303 ALTER EXTENSION ip4r ADD FUNCTION ipaddress_eq(ipaddress,ipaddress);
304 ALTER EXTENSION ip4r ADD FUNCTION iprange_eq(iprange,iprange);
305 ALTER EXTENSION ip4r ADD OPERATOR =(ip4,ip4);
306 ALTER EXTENSION ip4r ADD OPERATOR =(ip4r,ip4r);
307 ALTER EXTENSION ip4r ADD OPERATOR =(ip6,ip6);
308 ALTER EXTENSION ip4r ADD OPERATOR =(ip6r,ip6r);
309 ALTER EXTENSION ip4r ADD OPERATOR =(ipaddress,ipaddress);
310 ALTER EXTENSION ip4r ADD OPERATOR =(iprange,iprange);
311 ALTER EXTENSION ip4r ADD FUNCTION ip4_ge(ip4,ip4);
312 ALTER EXTENSION ip4r ADD FUNCTION ip4r_ge(ip4r,ip4r);
313 ALTER EXTENSION ip4r ADD FUNCTION ip6_ge(ip6,ip6);
314 ALTER EXTENSION ip4r ADD FUNCTION ip6r_ge(ip6r,ip6r);
315 ALTER EXTENSION ip4r ADD FUNCTION ipaddress_ge(ipaddress,ipaddress);
316 ALTER EXTENSION ip4r ADD FUNCTION iprange_ge(iprange,iprange);
317 ALTER EXTENSION ip4r ADD OPERATOR >=(ip4,ip4);
318 ALTER EXTENSION ip4r ADD OPERATOR >=(ip4r,ip4r);
319 ALTER EXTENSION ip4r ADD OPERATOR >=(ip6,ip6);
320 ALTER EXTENSION ip4r ADD OPERATOR >=(ip6r,ip6r);
321 ALTER EXTENSION ip4r ADD OPERATOR >=(ipaddress,ipaddress);
322 ALTER EXTENSION ip4r ADD OPERATOR >=(iprange,iprange);
323 ALTER EXTENSION ip4r ADD FUNCTION ip4_gt(ip4,ip4);
324 ALTER EXTENSION ip4r ADD FUNCTION ip4r_gt(ip4r,ip4r);
325 ALTER EXTENSION ip4r ADD FUNCTION ip6_gt(ip6,ip6);
326 ALTER EXTENSION ip4r ADD FUNCTION ip6r_gt(ip6r,ip6r);
327 ALTER EXTENSION ip4r ADD FUNCTION ipaddress_gt(ipaddress,ipaddress);
328 ALTER EXTENSION ip4r ADD FUNCTION iprange_gt(iprange,iprange);
329 ALTER EXTENSION ip4r ADD OPERATOR >(ip4,ip4);
330 ALTER EXTENSION ip4r ADD OPERATOR >(ip4r,ip4r);
331 ALTER EXTENSION ip4r ADD OPERATOR >(ip6,ip6);
332 ALTER EXTENSION ip4r ADD OPERATOR >(ip6r,ip6r);
333 ALTER EXTENSION ip4r ADD OPERATOR >(ipaddress,ipaddress);
334 ALTER EXTENSION ip4r ADD OPERATOR >(iprange,iprange);
335 ALTER EXTENSION ip4r ADD FUNCTION ip4_le(ip4,ip4);
336 ALTER EXTENSION ip4r ADD FUNCTION ip4r_le(ip4r,ip4r);
337 ALTER EXTENSION ip4r ADD FUNCTION ip6_le(ip6,ip6);
338 ALTER EXTENSION ip4r ADD FUNCTION ip6r_le(ip6r,ip6r);
339 ALTER EXTENSION ip4r ADD FUNCTION ipaddress_le(ipaddress,ipaddress);
340 ALTER EXTENSION ip4r ADD FUNCTION iprange_le(iprange,iprange);
341 ALTER EXTENSION ip4r ADD OPERATOR <=(ip4,ip4);
342 ALTER EXTENSION ip4r ADD OPERATOR <=(ip4r,ip4r);
343 ALTER EXTENSION ip4r ADD OPERATOR <=(ip6,ip6);
344 ALTER EXTENSION ip4r ADD OPERATOR <=(ip6r,ip6r);
345 ALTER EXTENSION ip4r ADD OPERATOR <=(ipaddress,ipaddress);
346 ALTER EXTENSION ip4r ADD OPERATOR <=(iprange,iprange);
347 ALTER EXTENSION ip4r ADD FUNCTION ip4_lt(ip4,ip4);
348 ALTER EXTENSION ip4r ADD FUNCTION ip4r_lt(ip4r,ip4r);
349 ALTER EXTENSION ip4r ADD FUNCTION ip6_lt(ip6,ip6);
350 ALTER EXTENSION ip4r ADD FUNCTION ip6r_lt(ip6r,ip6r);
351 ALTER EXTENSION ip4r ADD FUNCTION ipaddress_lt(ipaddress,ipaddress);
352 ALTER EXTENSION ip4r ADD FUNCTION iprange_lt(iprange,iprange);
353 ALTER EXTENSION ip4r ADD OPERATOR <(ip4,ip4);
354 ALTER EXTENSION ip4r ADD OPERATOR <(ip4r,ip4r);
355 ALTER EXTENSION ip4r ADD OPERATOR <(ip6,ip6);
356 ALTER EXTENSION ip4r ADD OPERATOR <(ip6r,ip6r);
357 ALTER EXTENSION ip4r ADD OPERATOR <(ipaddress,ipaddress);
358 ALTER EXTENSION ip4r ADD OPERATOR <(iprange,iprange);
359 ALTER EXTENSION ip4r ADD FUNCTION ip4_neq(ip4,ip4);
360 ALTER EXTENSION ip4r ADD FUNCTION ip4r_neq(ip4r,ip4r);
361 ALTER EXTENSION ip4r ADD FUNCTION ip6_neq(ip6,ip6);
362 ALTER EXTENSION ip4r ADD FUNCTION ip6r_neq(ip6r,ip6r);
363 ALTER EXTENSION ip4r ADD FUNCTION ipaddress_neq(ipaddress,ipaddress);
364 ALTER EXTENSION ip4r ADD FUNCTION iprange_neq(iprange,iprange);
365 ALTER EXTENSION ip4r ADD OPERATOR <>(ip4,ip4);
366 ALTER EXTENSION ip4r ADD OPERATOR <>(ip4r,ip4r);
367 ALTER EXTENSION ip4r ADD OPERATOR <>(ip6,ip6);
368 ALTER EXTENSION ip4r ADD OPERATOR <>(ip6r,ip6r);
369 ALTER EXTENSION ip4r ADD OPERATOR <>(ipaddress,ipaddress);
370 ALTER EXTENSION ip4r ADD OPERATOR <>(iprange,iprange);
371 ALTER EXTENSION ip4r ADD FUNCTION ip4_cmp(ip4,ip4);
372 ALTER EXTENSION ip4r ADD FUNCTION ip4r_cmp(ip4r,ip4r);
373 ALTER EXTENSION ip4r ADD FUNCTION ip6_cmp(ip6,ip6);
374 ALTER EXTENSION ip4r ADD FUNCTION ip6r_cmp(ip6r,ip6r);
375 ALTER EXTENSION ip4r ADD FUNCTION ipaddress_cmp(ipaddress,ipaddress);
376 ALTER EXTENSION ip4r ADD FUNCTION iprange_cmp(iprange,iprange);
377 ALTER EXTENSION ip4r ADD OPERATOR CLASS btree_ip4_ops USING btree;
378 ALTER EXTENSION ip4r ADD OPERATOR CLASS btree_ip4r_ops USING btree;
379 ALTER EXTENSION ip4r ADD OPERATOR CLASS btree_ip6_ops USING btree;
380 ALTER EXTENSION ip4r ADD OPERATOR CLASS btree_ip6r_ops USING btree;
381 ALTER EXTENSION ip4r ADD OPERATOR CLASS btree_ipaddress_ops USING btree;
382 ALTER EXTENSION ip4r ADD OPERATOR CLASS btree_iprange_ops USING btree;
383 ALTER EXTENSION ip4r ADD FUNCTION ip4hash(ip4);
384 ALTER EXTENSION ip4r ADD FUNCTION ip6hash(ip6);
385 ALTER EXTENSION ip4r ADD FUNCTION ipaddresshash(ipaddress);
386 ALTER EXTENSION ip4r ADD FUNCTION ip4rhash(ip4r);
387 ALTER EXTENSION ip4r ADD FUNCTION ip6rhash(ip6r);
388 ALTER EXTENSION ip4r ADD FUNCTION iprangehash(iprange);
389 ALTER EXTENSION ip4r ADD OPERATOR CLASS hash_ip4_ops USING hash;
390 ALTER EXTENSION ip4r ADD OPERATOR CLASS hash_ip4r_ops USING hash;
391 ALTER EXTENSION ip4r ADD OPERATOR CLASS hash_ip6_ops USING hash;
392 ALTER EXTENSION ip4r ADD OPERATOR CLASS hash_ip6r_ops USING hash;
393 ALTER EXTENSION ip4r ADD OPERATOR CLASS hash_ipaddress_ops USING hash;
394 ALTER EXTENSION ip4r ADD OPERATOR CLASS hash_iprange_ops USING hash;
395 ALTER EXTENSION ip4r ADD FUNCTION gip4r_consistent(internal,ip4r,int2,oid,internal);
396 ALTER EXTENSION ip4r ADD FUNCTION gip4r_compress(internal);
397 ALTER EXTENSION ip4r ADD FUNCTION gip4r_decompress(internal);
398 ALTER EXTENSION ip4r ADD FUNCTION gip4r_penalty(internal,internal,internal);
399 ALTER EXTENSION ip4r ADD FUNCTION gip4r_picksplit(internal, internal);
400 ALTER EXTENSION ip4r ADD FUNCTION gip4r_union(internal, internal);
401 ALTER EXTENSION ip4r ADD FUNCTION gip4r_same(ip4r, ip4r, internal);
402 ALTER EXTENSION ip4r ADD FUNCTION gip4r_fetch(internal);
403 ALTER EXTENSION ip4r ADD FUNCTION gip6r_consistent(internal,ip6r,int2,oid,internal);
404 ALTER EXTENSION ip4r ADD FUNCTION gip6r_compress(internal);
405 ALTER EXTENSION ip4r ADD FUNCTION gip6r_decompress(internal);
406 ALTER EXTENSION ip4r ADD FUNCTION gip6r_penalty(internal,internal,internal);
407 ALTER EXTENSION ip4r ADD FUNCTION gip6r_picksplit(internal, internal);
408 ALTER EXTENSION ip4r ADD FUNCTION gip6r_union(internal, internal);
409 ALTER EXTENSION ip4r ADD FUNCTION gip6r_same(ip6r, ip6r, internal);
410 ALTER EXTENSION ip4r ADD FUNCTION gip6r_fetch(internal);
411 ALTER EXTENSION ip4r ADD FUNCTION gipr_consistent(internal,iprange,int2,oid,internal);
412 ALTER EXTENSION ip4r ADD FUNCTION gipr_compress(internal);
413 ALTER EXTENSION ip4r ADD FUNCTION gipr_decompress(internal);
414 ALTER EXTENSION ip4r ADD FUNCTION gipr_penalty(internal,internal,internal);
415 ALTER EXTENSION ip4r ADD FUNCTION gipr_picksplit(internal, internal);
416 ALTER EXTENSION ip4r ADD FUNCTION gipr_union(internal, internal);
417 ALTER EXTENSION ip4r ADD FUNCTION gipr_same(iprange, iprange, internal);
418 ALTER EXTENSION ip4r ADD FUNCTION gipr_fetch(internal);
419 ALTER EXTENSION ip4r ADD OPERATOR CLASS gist_ip4r_ops USING gist;
420 ALTER EXTENSION ip4r ADD OPERATOR CLASS gist_ip6r_ops USING gist;
421 ALTER EXTENSION ip4r ADD OPERATOR CLASS gist_iprange_ops USING gist;