pgLatLon
view latlon--0.5--0.6.sql @ 25:d8ac13006162
Added update script to version 0.6
| author | jbe |
|---|---|
| date | Thu Sep 22 21:57:03 2016 +0200 (2016-09-22) |
| parents | |
| children |
line source
2 CREATE OR REPLACE FUNCTION ekey_point_in_dummy(cstring)
3 RETURNS ekey_point
4 LANGUAGE C IMMUTABLE STRICT
5 AS '$libdir/latlon-v0006', 'pgl_notimpl';
7 CREATE OR REPLACE FUNCTION ekey_point_out_dummy(ekey_point)
8 RETURNS cstring
9 LANGUAGE C IMMUTABLE STRICT
10 AS '$libdir/latlon-v0006', 'pgl_notimpl';
12 CREATE OR REPLACE FUNCTION ekey_area_in_dummy(cstring)
13 RETURNS ekey_area
14 LANGUAGE C IMMUTABLE STRICT
15 AS '$libdir/latlon-v0006', 'pgl_notimpl';
17 CREATE OR REPLACE FUNCTION ekey_area_out_dummy(ekey_area)
18 RETURNS cstring
19 LANGUAGE C IMMUTABLE STRICT
20 AS '$libdir/latlon-v0006', 'pgl_notimpl';
22 CREATE OR REPLACE FUNCTION epoint_in(cstring)
23 RETURNS epoint
24 LANGUAGE C IMMUTABLE STRICT
25 AS '$libdir/latlon-v0006', 'pgl_epoint_in';
27 CREATE OR REPLACE FUNCTION ebox_in(cstring)
28 RETURNS ebox
29 LANGUAGE C IMMUTABLE STRICT
30 AS '$libdir/latlon-v0006', 'pgl_ebox_in';
32 CREATE OR REPLACE FUNCTION ecircle_in(cstring)
33 RETURNS ecircle
34 LANGUAGE C IMMUTABLE STRICT
35 AS '$libdir/latlon-v0006', 'pgl_ecircle_in';
37 CREATE OR REPLACE FUNCTION ecluster_in(cstring)
38 RETURNS ecluster
39 LANGUAGE C IMMUTABLE STRICT
40 AS '$libdir/latlon-v0006', 'pgl_ecluster_in';
42 CREATE OR REPLACE FUNCTION epoint_out(epoint)
43 RETURNS cstring
44 LANGUAGE C IMMUTABLE STRICT
45 AS '$libdir/latlon-v0006', 'pgl_epoint_out';
47 CREATE OR REPLACE FUNCTION ebox_out(ebox)
48 RETURNS cstring
49 LANGUAGE C IMMUTABLE STRICT
50 AS '$libdir/latlon-v0006', 'pgl_ebox_out';
52 CREATE OR REPLACE FUNCTION ecircle_out(ecircle)
53 RETURNS cstring
54 LANGUAGE C IMMUTABLE STRICT
55 AS '$libdir/latlon-v0006', 'pgl_ecircle_out';
57 CREATE OR REPLACE FUNCTION ecluster_out(ecluster)
58 RETURNS cstring
59 LANGUAGE C IMMUTABLE STRICT
60 AS '$libdir/latlon-v0006', 'pgl_ecluster_out';
62 CREATE OR REPLACE FUNCTION epoint_recv(internal)
63 RETURNS epoint
64 LANGUAGE C IMMUTABLE STRICT
65 AS '$libdir/latlon-v0006', 'pgl_epoint_recv';
67 CREATE OR REPLACE FUNCTION ebox_recv(internal)
68 RETURNS ebox
69 LANGUAGE C IMMUTABLE STRICT
70 AS '$libdir/latlon-v0006', 'pgl_ebox_recv';
72 CREATE OR REPLACE FUNCTION ecircle_recv(internal)
73 RETURNS ecircle
74 LANGUAGE C IMMUTABLE STRICT
75 AS '$libdir/latlon-v0006', 'pgl_ecircle_recv';
77 CREATE OR REPLACE FUNCTION epoint_send(epoint)
78 RETURNS bytea
79 LANGUAGE C IMMUTABLE STRICT
80 AS '$libdir/latlon-v0006', 'pgl_epoint_send';
82 CREATE OR REPLACE FUNCTION ebox_send(ebox)
83 RETURNS bytea
84 LANGUAGE C IMMUTABLE STRICT
85 AS '$libdir/latlon-v0006', 'pgl_ebox_send';
87 CREATE OR REPLACE FUNCTION ecircle_send(ecircle)
88 RETURNS bytea
89 LANGUAGE C IMMUTABLE STRICT
90 AS '$libdir/latlon-v0006', 'pgl_ecircle_send';
92 CREATE OR REPLACE FUNCTION epoint_btree_lt(epoint, epoint)
93 RETURNS boolean
94 LANGUAGE C IMMUTABLE STRICT
95 AS '$libdir/latlon-v0006', 'pgl_btree_epoint_lt';
97 CREATE OR REPLACE FUNCTION epoint_btree_le(epoint, epoint)
98 RETURNS boolean
99 LANGUAGE C IMMUTABLE STRICT
100 AS '$libdir/latlon-v0006', 'pgl_btree_epoint_le';
102 CREATE OR REPLACE FUNCTION epoint_btree_eq(epoint, epoint)
103 RETURNS boolean
104 LANGUAGE C IMMUTABLE STRICT
105 AS '$libdir/latlon-v0006', 'pgl_btree_epoint_eq';
107 CREATE OR REPLACE FUNCTION epoint_btree_ne(epoint, epoint)
108 RETURNS boolean
109 LANGUAGE C IMMUTABLE STRICT
110 AS '$libdir/latlon-v0006', 'pgl_btree_epoint_ne';
112 CREATE OR REPLACE FUNCTION epoint_btree_ge(epoint, epoint)
113 RETURNS boolean
114 LANGUAGE C IMMUTABLE STRICT
115 AS '$libdir/latlon-v0006', 'pgl_btree_epoint_ge';
117 CREATE OR REPLACE FUNCTION epoint_btree_gt(epoint, epoint)
118 RETURNS boolean
119 LANGUAGE C IMMUTABLE STRICT
120 AS '$libdir/latlon-v0006', 'pgl_btree_epoint_gt';
122 CREATE OR REPLACE FUNCTION epoint_btree_cmp(epoint, epoint)
123 RETURNS int4
124 LANGUAGE C IMMUTABLE STRICT
125 AS '$libdir/latlon-v0006', 'pgl_btree_epoint_cmp';
127 CREATE OR REPLACE FUNCTION ebox_btree_lt(ebox, ebox)
128 RETURNS boolean
129 LANGUAGE C IMMUTABLE STRICT
130 AS '$libdir/latlon-v0006', 'pgl_btree_ebox_lt';
132 CREATE OR REPLACE FUNCTION ebox_btree_le(ebox, ebox)
133 RETURNS boolean
134 LANGUAGE C IMMUTABLE STRICT
135 AS '$libdir/latlon-v0006', 'pgl_btree_ebox_le';
137 CREATE OR REPLACE FUNCTION ebox_btree_eq(ebox, ebox)
138 RETURNS boolean
139 LANGUAGE C IMMUTABLE STRICT
140 AS '$libdir/latlon-v0006', 'pgl_btree_ebox_eq';
142 CREATE OR REPLACE FUNCTION ebox_btree_ne(ebox, ebox)
143 RETURNS boolean
144 LANGUAGE C IMMUTABLE STRICT
145 AS '$libdir/latlon-v0006', 'pgl_btree_ebox_ne';
147 CREATE OR REPLACE FUNCTION ebox_btree_ge(ebox, ebox)
148 RETURNS boolean
149 LANGUAGE C IMMUTABLE STRICT
150 AS '$libdir/latlon-v0006', 'pgl_btree_ebox_ge';
152 CREATE OR REPLACE FUNCTION ebox_btree_gt(ebox, ebox)
153 RETURNS boolean
154 LANGUAGE C IMMUTABLE STRICT
155 AS '$libdir/latlon-v0006', 'pgl_btree_ebox_gt';
157 CREATE OR REPLACE FUNCTION ebox_btree_cmp(ebox, ebox)
158 RETURNS int4
159 LANGUAGE C IMMUTABLE STRICT
160 AS '$libdir/latlon-v0006', 'pgl_btree_ebox_cmp';
162 CREATE OR REPLACE FUNCTION ecircle_btree_lt(ecircle, ecircle)
163 RETURNS boolean
164 LANGUAGE C IMMUTABLE STRICT
165 AS '$libdir/latlon-v0006', 'pgl_btree_ecircle_lt';
167 CREATE OR REPLACE FUNCTION ecircle_btree_le(ecircle, ecircle)
168 RETURNS boolean
169 LANGUAGE C IMMUTABLE STRICT
170 AS '$libdir/latlon-v0006', 'pgl_btree_ecircle_le';
172 CREATE OR REPLACE FUNCTION ecircle_btree_eq(ecircle, ecircle)
173 RETURNS boolean
174 LANGUAGE C IMMUTABLE STRICT
175 AS '$libdir/latlon-v0006', 'pgl_btree_ecircle_eq';
177 CREATE OR REPLACE FUNCTION ecircle_btree_ne(ecircle, ecircle)
178 RETURNS boolean
179 LANGUAGE C IMMUTABLE STRICT
180 AS '$libdir/latlon-v0006', 'pgl_btree_ecircle_ne';
182 CREATE OR REPLACE FUNCTION ecircle_btree_ge(ecircle, ecircle)
183 RETURNS boolean
184 LANGUAGE C IMMUTABLE STRICT
185 AS '$libdir/latlon-v0006', 'pgl_btree_ecircle_ge';
187 CREATE OR REPLACE FUNCTION ecircle_btree_gt(ecircle, ecircle)
188 RETURNS boolean
189 LANGUAGE C IMMUTABLE STRICT
190 AS '$libdir/latlon-v0006', 'pgl_btree_ecircle_gt';
192 CREATE OR REPLACE FUNCTION ecircle_btree_cmp(ecircle, ecircle)
193 RETURNS int4
194 LANGUAGE C IMMUTABLE STRICT
195 AS '$libdir/latlon-v0006', 'pgl_btree_ecircle_cmp';
197 CREATE OR REPLACE FUNCTION cast_epoint_to_ebox(epoint)
198 RETURNS ebox
199 LANGUAGE C IMMUTABLE STRICT
200 AS '$libdir/latlon-v0006', 'pgl_epoint_to_ebox';
202 CREATE OR REPLACE FUNCTION cast_epoint_to_ecircle(epoint)
203 RETURNS ecircle
204 LANGUAGE C IMMUTABLE STRICT
205 AS '$libdir/latlon-v0006', 'pgl_epoint_to_ecircle';
207 CREATE OR REPLACE FUNCTION cast_epoint_to_ecluster(epoint)
208 RETURNS ecluster
209 LANGUAGE C IMMUTABLE STRICT
210 AS '$libdir/latlon-v0006', 'pgl_epoint_to_ecluster';
212 CREATE OR REPLACE FUNCTION cast_ebox_to_ecluster(ebox)
213 RETURNS ecluster
214 LANGUAGE C IMMUTABLE STRICT
215 AS '$libdir/latlon-v0006', 'pgl_ebox_to_ecluster';
217 CREATE OR REPLACE FUNCTION epoint(float8, float8)
218 RETURNS epoint
219 LANGUAGE C IMMUTABLE STRICT
220 AS '$libdir/latlon-v0006', 'pgl_create_epoint';
222 CREATE OR REPLACE FUNCTION empty_ebox()
223 RETURNS ebox
224 LANGUAGE C IMMUTABLE STRICT
225 AS '$libdir/latlon-v0006', 'pgl_create_empty_ebox';
227 CREATE OR REPLACE FUNCTION ebox(float8, float8, float8, float8)
228 RETURNS ebox
229 LANGUAGE C IMMUTABLE STRICT
230 AS '$libdir/latlon-v0006', 'pgl_create_ebox';
232 CREATE OR REPLACE FUNCTION ebox(epoint, epoint)
233 RETURNS ebox
234 LANGUAGE C IMMUTABLE STRICT
235 AS '$libdir/latlon-v0006', 'pgl_create_ebox_from_epoints';
237 CREATE OR REPLACE FUNCTION ecircle(float8, float8, float8)
238 RETURNS ecircle
239 LANGUAGE C IMMUTABLE STRICT
240 AS '$libdir/latlon-v0006', 'pgl_create_ecircle';
242 CREATE OR REPLACE FUNCTION ecircle(epoint, float8)
243 RETURNS ecircle
244 LANGUAGE C IMMUTABLE STRICT
245 AS '$libdir/latlon-v0006', 'pgl_create_ecircle_from_epoint';
247 CREATE OR REPLACE FUNCTION latitude(epoint)
248 RETURNS float8
249 LANGUAGE C IMMUTABLE STRICT
250 AS '$libdir/latlon-v0006', 'pgl_epoint_lat';
252 CREATE OR REPLACE FUNCTION longitude(epoint)
253 RETURNS float8
254 LANGUAGE C IMMUTABLE STRICT
255 AS '$libdir/latlon-v0006', 'pgl_epoint_lon';
257 CREATE OR REPLACE FUNCTION min_latitude(ebox)
258 RETURNS float8
259 LANGUAGE C IMMUTABLE STRICT
260 AS '$libdir/latlon-v0006', 'pgl_ebox_lat_min';
262 CREATE OR REPLACE FUNCTION max_latitude(ebox)
263 RETURNS float8
264 LANGUAGE C IMMUTABLE STRICT
265 AS '$libdir/latlon-v0006', 'pgl_ebox_lat_max';
267 CREATE OR REPLACE FUNCTION min_longitude(ebox)
268 RETURNS float8
269 LANGUAGE C IMMUTABLE STRICT
270 AS '$libdir/latlon-v0006', 'pgl_ebox_lon_min';
272 CREATE OR REPLACE FUNCTION max_longitude(ebox)
273 RETURNS float8
274 LANGUAGE C IMMUTABLE STRICT
275 AS '$libdir/latlon-v0006', 'pgl_ebox_lon_max';
277 CREATE OR REPLACE FUNCTION center(ecircle)
278 RETURNS epoint
279 LANGUAGE C IMMUTABLE STRICT
280 AS '$libdir/latlon-v0006', 'pgl_ecircle_center';
282 CREATE OR REPLACE FUNCTION radius(ecircle)
283 RETURNS float8
284 LANGUAGE C IMMUTABLE STRICT
285 AS '$libdir/latlon-v0006', 'pgl_ecircle_radius';
287 CREATE OR REPLACE FUNCTION epoint_ebox_overlap_proc(epoint, ebox)
288 RETURNS boolean
289 LANGUAGE C IMMUTABLE STRICT
290 AS '$libdir/latlon-v0006', 'pgl_epoint_ebox_overlap';
292 CREATE OR REPLACE FUNCTION epoint_ecircle_overlap_proc(epoint, ecircle)
293 RETURNS boolean
294 LANGUAGE C IMMUTABLE STRICT
295 AS '$libdir/latlon-v0006', 'pgl_epoint_ecircle_overlap';
297 CREATE OR REPLACE FUNCTION epoint_ecluster_overlap_proc(epoint, ecluster)
298 RETURNS boolean
299 LANGUAGE C IMMUTABLE STRICT
300 AS '$libdir/latlon-v0006', 'pgl_epoint_ecluster_overlap';
302 CREATE OR REPLACE FUNCTION epoint_ecluster_may_overlap_proc(epoint, ecluster)
303 RETURNS boolean
304 LANGUAGE C IMMUTABLE STRICT
305 AS '$libdir/latlon-v0006', 'pgl_epoint_ecluster_may_overlap';
307 CREATE OR REPLACE FUNCTION ebox_overlap_proc(ebox, ebox)
308 RETURNS boolean
309 LANGUAGE C IMMUTABLE STRICT
310 AS '$libdir/latlon-v0006', 'pgl_ebox_overlap';
312 CREATE OR REPLACE FUNCTION ebox_ecircle_may_overlap_proc(ebox, ecircle)
313 RETURNS boolean
314 LANGUAGE C IMMUTABLE STRICT
315 AS '$libdir/latlon-v0006', 'pgl_ebox_ecircle_may_overlap';
317 CREATE OR REPLACE FUNCTION ebox_ecluster_may_overlap_proc(ebox, ecluster)
318 RETURNS boolean
319 LANGUAGE C IMMUTABLE STRICT
320 AS '$libdir/latlon-v0006', 'pgl_ebox_ecluster_may_overlap';
322 CREATE OR REPLACE FUNCTION ecircle_overlap_proc(ecircle, ecircle)
323 RETURNS boolean
324 LANGUAGE C IMMUTABLE STRICT
325 AS '$libdir/latlon-v0006', 'pgl_ecircle_overlap';
327 CREATE OR REPLACE FUNCTION ecircle_ecluster_overlap_proc(ecircle, ecluster)
328 RETURNS boolean
329 LANGUAGE C IMMUTABLE STRICT
330 AS '$libdir/latlon-v0006', 'pgl_ecircle_ecluster_overlap';
332 CREATE OR REPLACE FUNCTION ecircle_ecluster_may_overlap_proc(ecircle, ecluster)
333 RETURNS boolean
334 LANGUAGE C IMMUTABLE STRICT
335 AS '$libdir/latlon-v0006', 'pgl_ecircle_ecluster_may_overlap';
337 CREATE OR REPLACE FUNCTION ecluster_overlap_proc(ecluster, ecluster)
338 RETURNS boolean
339 LANGUAGE C IMMUTABLE STRICT
340 AS '$libdir/latlon-v0006', 'pgl_ecluster_overlap';
342 CREATE OR REPLACE FUNCTION ecluster_may_overlap_proc(ecluster, ecluster)
343 RETURNS boolean
344 LANGUAGE C IMMUTABLE STRICT
345 AS '$libdir/latlon-v0006', 'pgl_ecluster_may_overlap';
347 CREATE OR REPLACE FUNCTION ecluster_contains_proc(ecluster, ecluster)
348 RETURNS boolean
349 LANGUAGE C IMMUTABLE STRICT
350 AS '$libdir/latlon-v0006', 'pgl_ecluster_contains';
352 CREATE OR REPLACE FUNCTION epoint_distance_proc(epoint, epoint)
353 RETURNS float8
354 LANGUAGE C IMMUTABLE STRICT
355 AS '$libdir/latlon-v0006', 'pgl_epoint_distance';
357 CREATE OR REPLACE FUNCTION epoint_ecircle_distance_proc(epoint, ecircle)
358 RETURNS float8
359 LANGUAGE C IMMUTABLE STRICT
360 AS '$libdir/latlon-v0006', 'pgl_epoint_ecircle_distance';
362 CREATE OR REPLACE FUNCTION epoint_ecluster_distance_proc(epoint, ecluster)
363 RETURNS float8
364 LANGUAGE C IMMUTABLE STRICT
365 AS '$libdir/latlon-v0006', 'pgl_epoint_ecluster_distance';
367 CREATE OR REPLACE FUNCTION ecircle_distance_proc(ecircle, ecircle)
368 RETURNS float8
369 LANGUAGE C IMMUTABLE STRICT
370 AS '$libdir/latlon-v0006', 'pgl_ecircle_distance';
372 CREATE OR REPLACE FUNCTION ecircle_ecluster_distance_proc(ecircle, ecluster)
373 RETURNS float8
374 LANGUAGE C IMMUTABLE STRICT
375 AS '$libdir/latlon-v0006', 'pgl_ecircle_ecluster_distance';
377 CREATE OR REPLACE FUNCTION ecluster_distance_proc(ecluster, ecluster)
378 RETURNS float8
379 LANGUAGE C IMMUTABLE STRICT
380 AS '$libdir/latlon-v0006', 'pgl_ecluster_distance';
382 CREATE OR REPLACE FUNCTION pgl_gist_consistent(internal, internal, smallint, oid, internal)
383 RETURNS boolean
384 LANGUAGE C STRICT
385 AS '$libdir/latlon-v0006', 'pgl_gist_consistent';
387 CREATE OR REPLACE FUNCTION pgl_gist_union(internal, internal)
388 RETURNS internal
389 LANGUAGE C STRICT
390 AS '$libdir/latlon-v0006', 'pgl_gist_union';
392 CREATE OR REPLACE FUNCTION pgl_gist_compress_epoint(internal)
393 RETURNS internal
394 LANGUAGE C STRICT
395 AS '$libdir/latlon-v0006', 'pgl_gist_compress_epoint';
397 CREATE OR REPLACE FUNCTION pgl_gist_compress_ecircle(internal)
398 RETURNS internal
399 LANGUAGE C STRICT
400 AS '$libdir/latlon-v0006', 'pgl_gist_compress_ecircle';
402 CREATE OR REPLACE FUNCTION pgl_gist_compress_ecluster(internal)
403 RETURNS internal
404 LANGUAGE C STRICT
405 AS '$libdir/latlon-v0006', 'pgl_gist_compress_ecluster';
407 CREATE OR REPLACE FUNCTION pgl_gist_decompress(internal)
408 RETURNS internal
409 LANGUAGE C STRICT
410 AS '$libdir/latlon-v0006', 'pgl_gist_decompress';
412 CREATE OR REPLACE FUNCTION pgl_gist_penalty(internal, internal, internal)
413 RETURNS internal
414 LANGUAGE C STRICT
415 AS '$libdir/latlon-v0006', 'pgl_gist_penalty';
417 CREATE OR REPLACE FUNCTION pgl_gist_picksplit(internal, internal)
418 RETURNS internal
419 LANGUAGE C STRICT
420 AS '$libdir/latlon-v0006', 'pgl_gist_picksplit';
422 CREATE OR REPLACE FUNCTION pgl_gist_same(internal, internal, internal)
423 RETURNS internal
424 LANGUAGE C STRICT
425 AS '$libdir/latlon-v0006', 'pgl_gist_same';
427 CREATE OR REPLACE FUNCTION pgl_gist_distance(internal, internal, smallint, oid)
428 RETURNS internal
429 LANGUAGE C STRICT
430 AS '$libdir/latlon-v0006', 'pgl_gist_distance';