1
1
--
2
2
-- PostgreSQL code for IP addresses.
3
3
--
4
- -- $Id: ip.sql,v 1.4 1998/06/16 04:34:30 momjian Exp $
4
+ -- $Id: ip.sql,v 1.5 1998/06/16 05:35:10 momjian Exp $
5
5
-- Invoced from 1998/02/14 17:58:04 scrappy
6
6
--
7
7
-- New - INPUT/OUTPUT, functions, indexing by btree, test.
8
8
-- PART # 1 - ip.sql - load new type, functions and operators.
9
9
-- Then you should execute ipi.sql - add ipaddr_ops class to allow indexing.
10
10
11
- load ' /usr/local/pgsql/modules /ip.so' ;
11
+ load ' /usr/local/pgsql/contrib/ip_and_macs /ip.so' ;
12
12
13
13
--
14
14
-- Input and output functions and the type itself:
@@ -20,14 +20,14 @@ load '/usr/local/pgsql/modules/ip.so';
20
20
21
21
create function ipaddr_in (opaque)
22
22
returns opaque
23
- as ' /usr/local/pgsql/modules /ip.so'
23
+ as ' /usr/local/pgsql/contrib/ip_and_macs /ip.so'
24
24
language ' c' ;
25
25
26
26
27
27
28
28
create function ipaddr_out (opaque)
29
29
returns opaque
30
- as ' /usr/local/pgsql/modules /ip.so'
30
+ as ' /usr/local/pgsql/contrib/ip_and_macs /ip.so'
31
31
language ' c' ;
32
32
33
33
create type ipaddr (
@@ -46,7 +46,7 @@ create type ipaddr (
46
46
drop function ipaddr_print;
47
47
create function ipaddr_print (ipaddr, text )
48
48
returns text
49
- as ' /usr/local/pgsql/modules /ip.so'
49
+ as ' /usr/local/pgsql/contrib/ip_and_macs /ip.so'
50
50
language ' c' ;
51
51
);
52
52
@@ -58,32 +58,32 @@ create function ipaddr_print(ipaddr, text)
58
58
59
59
create function ipaddr_lt (ipaddr, ipaddr)
60
60
returns bool
61
- as ' /usr/local/pgsql/modules /ip.so'
61
+ as ' /usr/local/pgsql/contrib/ip_and_macs /ip.so'
62
62
language ' c' ;
63
63
64
64
create function ipaddr_le (ipaddr, ipaddr)
65
65
returns bool
66
- as ' /usr/local/pgsql/modules /ip.so'
66
+ as ' /usr/local/pgsql/contrib/ip_and_macs /ip.so'
67
67
language ' c' ;
68
68
69
69
create function ipaddr_eq (ipaddr, ipaddr)
70
70
returns bool
71
- as ' /usr/local/pgsql/modules /ip.so'
71
+ as ' /usr/local/pgsql/contrib/ip_and_macs /ip.so'
72
72
language ' c' ;
73
73
74
74
create function ipaddr_ge (ipaddr, ipaddr)
75
75
returns bool
76
- as ' /usr/local/pgsql/modules /ip.so'
76
+ as ' /usr/local/pgsql/contrib/ip_and_macs /ip.so'
77
77
language ' c' ;
78
78
79
79
create function ipaddr_gt (ipaddr, ipaddr)
80
80
returns bool
81
- as ' /usr/local/pgsql/modules /ip.so'
81
+ as ' /usr/local/pgsql/contrib/ip_and_macs /ip.so'
82
82
language ' c' ;
83
83
84
84
create function ipaddr_ne (ipaddr, ipaddr)
85
85
returns bool
86
- as ' /usr/local/pgsql/modules /ip.so'
86
+ as ' /usr/local/pgsql/contrib/ip_and_macs /ip.so'
87
87
language ' c' ;
88
88
89
89
--
@@ -92,7 +92,7 @@ create function ipaddr_ne(ipaddr, ipaddr)
92
92
--
93
93
create function ipaddr_in_net (ipaddr, ipaddr)
94
94
returns bool
95
- as ' /usr/local/pgsql/modules /ip.so'
95
+ as ' /usr/local/pgsql/contrib/ip_and_macs /ip.so'
96
96
language ' c' ;
97
97
98
98
--
@@ -104,7 +104,7 @@ create function ipaddr_in_net(ipaddr, ipaddr)
104
104
105
105
create function ipaddr_net (ipaddr)
106
106
returns ipaddr
107
- as ' /usr/local/pgsql/modules /ip.so'
107
+ as ' /usr/local/pgsql/contrib/ip_and_macs /ip.so'
108
108
language ' c' ;
109
109
110
110
--
@@ -114,7 +114,7 @@ create function ipaddr_in_net(ipaddr, ipaddr)
114
114
115
115
create function ipaddr_is_net (ipaddr)
116
116
returns boolean
117
- as ' /usr/local/pgsql/modules /ip.so'
117
+ as ' /usr/local/pgsql/contrib/ip_and_macs /ip.so'
118
118
language ' c' ;
119
119
120
120
--
@@ -123,7 +123,7 @@ create function ipaddr_in_net(ipaddr, ipaddr)
123
123
124
124
create function ipaddr_len (ipaddr)
125
125
returns int4
126
- as ' /usr/local/pgsql/modules /ip.so'
126
+ as ' /usr/local/pgsql/contrib/ip_and_macs /ip.so'
127
127
language ' c' ;
128
128
129
129
--
@@ -132,7 +132,7 @@ create function ipaddr_in_net(ipaddr, ipaddr)
132
132
133
133
create function ipaddr_pref (ipaddr)
134
134
returns int4
135
- as ' /usr/local/pgsql/modules /ip.so'
135
+ as ' /usr/local/pgsql/contrib/ip_and_macs /ip.so'
136
136
language ' c' ;
137
137
138
138
--
@@ -142,7 +142,7 @@ create function ipaddr_in_net(ipaddr, ipaddr)
142
142
143
143
create function ipaddr_integer (ipaddr)
144
144
returns int4
145
- as ' /usr/local/pgsql/modules /ip.so'
145
+ as ' /usr/local/pgsql/contrib/ip_and_macs /ip.so'
146
146
language ' c' ;
147
147
148
148
--
@@ -152,7 +152,7 @@ create function ipaddr_in_net(ipaddr, ipaddr)
152
152
153
153
create function ipaddr_compose (int4,int4)
154
154
returns ipaddr
155
- as ' /usr/local/pgsql/modules /ip.so'
155
+ as ' /usr/local/pgsql/contrib/ip_and_macs /ip.so'
156
156
language ' c' ;
157
157
158
158
--
@@ -161,7 +161,7 @@ create function ipaddr_in_net(ipaddr, ipaddr)
161
161
162
162
create function ipaddr_mask (ipaddr)
163
163
returns ipaddr
164
- as ' /usr/local/pgsql/modules /ip.so'
164
+ as ' /usr/local/pgsql/contrib/ip_and_macs /ip.so'
165
165
language ' c' ;
166
166
167
167
--
@@ -170,7 +170,7 @@ create function ipaddr_in_net(ipaddr, ipaddr)
170
170
171
171
create function ipaddr_bcast (ipaddr)
172
172
returns ipaddr
173
- as ' /usr/local/pgsql/modules /ip.so'
173
+ as ' /usr/local/pgsql/contrib/ip_and_macs /ip.so'
174
174
language ' c' ;
175
175
176
176
--
@@ -180,7 +180,7 @@ create function ipaddr_in_net(ipaddr, ipaddr)
180
180
181
181
create function ipaddr_cmp (ipaddr,ipaddr)
182
182
returns int4
183
- as ' /usr/local/pgsql/modules /ip.so'
183
+ as ' /usr/local/pgsql/contrib/ip_and_macs /ip.so'
184
184
language ' c' ;
185
185
186
186
--
@@ -189,12 +189,12 @@ create function ipaddr_in_net(ipaddr, ipaddr)
189
189
190
190
create function ipaddr_plus (ipaddr,int4)
191
191
returns ipaddr
192
- as ' /usr/local/pgsql/modules /ip.so'
192
+ as ' /usr/local/pgsql/contrib/ip_and_macs /ip.so'
193
193
language ' c' ;
194
194
195
195
create function ipaddr_minus (ipaddr,int4)
196
196
returns ipaddr
197
- as ' /usr/local/pgsql/modules /ip.so'
197
+ as ' /usr/local/pgsql/contrib/ip_and_macs /ip.so'
198
198
language ' c' ;
199
199
200
200
--
0 commit comments