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