pgLatLon
view latlon--0.1--0.2.sql @ 4:8f79d4a1cdc1
New version 0.2 and update script from version 0.1
| author | jbe |
|---|---|
| date | Mon Aug 22 21:51:33 2016 +0200 (2016-08-22) |
| parents | latlon--0.1.sql@3b70e93cc07d |
| 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-v0002', '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-v0002', '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-v0002', '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-v0002', 'pgl_notimpl';
22 CREATE OR REPLACE FUNCTION epoint_in(cstring)
23 RETURNS epoint
24 LANGUAGE C IMMUTABLE STRICT
25 AS '$libdir/latlon-v0002', 'pgl_epoint_in';
27 CREATE OR REPLACE FUNCTION ebox_in(cstring)
28 RETURNS ebox
29 LANGUAGE C IMMUTABLE STRICT
30 AS '$libdir/latlon-v0002', 'pgl_ebox_in';
32 CREATE OR REPLACE FUNCTION ecircle_in(cstring)
33 RETURNS ecircle
34 LANGUAGE C IMMUTABLE STRICT
35 AS '$libdir/latlon-v0002', 'pgl_ecircle_in';
37 CREATE OR REPLACE FUNCTION ecluster_in(cstring)
38 RETURNS ecluster
39 LANGUAGE C IMMUTABLE STRICT
40 AS '$libdir/latlon-v0002', 'pgl_ecluster_in';
42 CREATE OR REPLACE FUNCTION epoint_out(epoint)
43 RETURNS cstring
44 LANGUAGE C IMMUTABLE STRICT
45 AS '$libdir/latlon-v0002', 'pgl_epoint_out';
47 CREATE OR REPLACE FUNCTION ebox_out(ebox)
48 RETURNS cstring
49 LANGUAGE C IMMUTABLE STRICT
50 AS '$libdir/latlon-v0002', 'pgl_ebox_out';
52 CREATE OR REPLACE FUNCTION ecircle_out(ecircle)
53 RETURNS cstring
54 LANGUAGE C IMMUTABLE STRICT
55 AS '$libdir/latlon-v0002', 'pgl_ecircle_out';
57 CREATE OR REPLACE FUNCTION ecluster_out(ecluster)
58 RETURNS cstring
59 LANGUAGE C IMMUTABLE STRICT
60 AS '$libdir/latlon-v0002', 'pgl_ecluster_out';
62 CREATE OR REPLACE FUNCTION epoint_recv(internal)
63 RETURNS epoint
64 LANGUAGE C IMMUTABLE STRICT
65 AS '$libdir/latlon-v0002', 'pgl_epoint_recv';
67 CREATE OR REPLACE FUNCTION ebox_recv(internal)
68 RETURNS ebox
69 LANGUAGE C IMMUTABLE STRICT
70 AS '$libdir/latlon-v0002', 'pgl_ebox_recv';
72 CREATE OR REPLACE FUNCTION ecircle_recv(internal)
73 RETURNS ecircle
74 LANGUAGE C IMMUTABLE STRICT
75 AS '$libdir/latlon-v0002', 'pgl_ecircle_recv';
77 CREATE OR REPLACE FUNCTION epoint_send(epoint)
78 RETURNS bytea
79 LANGUAGE C IMMUTABLE STRICT
80 AS '$libdir/latlon-v0002', 'pgl_epoint_send';
82 CREATE OR REPLACE FUNCTION ebox_send(ebox)
83 RETURNS bytea
84 LANGUAGE C IMMUTABLE STRICT
85 AS '$libdir/latlon-v0002', 'pgl_ebox_send';
87 CREATE OR REPLACE FUNCTION ecircle_send(ecircle)
88 RETURNS bytea
89 LANGUAGE C IMMUTABLE STRICT
90 AS '$libdir/latlon-v0002', '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-v0002', '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-v0002', '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-v0002', '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-v0002', '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-v0002', '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-v0002', '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-v0002', '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-v0002', '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-v0002', '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-v0002', '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-v0002', '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-v0002', '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-v0002', '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-v0002', '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-v0002', '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-v0002', '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-v0002', '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-v0002', '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-v0002', '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-v0002', '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-v0002', '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-v0002', '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-v0002', '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-v0002', '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-v0002', 'pgl_ebox_to_ecluster';
217 CREATE OR REPLACE FUNCTION epoint(float8, float8)
218 RETURNS epoint
219 LANGUAGE C IMMUTABLE STRICT
220 AS '$libdir/latlon-v0002', 'pgl_create_epoint';
222 CREATE OR REPLACE FUNCTION empty_ebox()
223 RETURNS ebox
224 LANGUAGE C IMMUTABLE STRICT
225 AS '$libdir/latlon-v0002', '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-v0002', 'pgl_create_ebox';
232 CREATE OR REPLACE FUNCTION ebox(epoint, epoint)
233 RETURNS ebox
234 LANGUAGE C IMMUTABLE STRICT
235 AS '$libdir/latlon-v0002', '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-v0002', 'pgl_create_ecircle';
242 CREATE OR REPLACE FUNCTION ecircle(epoint, float8)
243 RETURNS ecircle
244 LANGUAGE C IMMUTABLE STRICT
245 AS '$libdir/latlon-v0002', 'pgl_create_ecircle_from_epoint';
247 CREATE OR REPLACE FUNCTION latitude(epoint)
248 RETURNS float8
249 LANGUAGE C IMMUTABLE STRICT
250 AS '$libdir/latlon-v0002', 'pgl_epoint_lat';
252 CREATE OR REPLACE FUNCTION longitude(epoint)
253 RETURNS float8
254 LANGUAGE C IMMUTABLE STRICT
255 AS '$libdir/latlon-v0002', 'pgl_epoint_lon';
257 CREATE OR REPLACE FUNCTION min_latitude(ebox)
258 RETURNS float8
259 LANGUAGE C IMMUTABLE STRICT
260 AS '$libdir/latlon-v0002', 'pgl_ebox_lat_min';
262 CREATE OR REPLACE FUNCTION max_latitude(ebox)
263 RETURNS float8
264 LANGUAGE C IMMUTABLE STRICT
265 AS '$libdir/latlon-v0002', 'pgl_ebox_lat_max';
267 CREATE OR REPLACE FUNCTION min_longitude(ebox)
268 RETURNS float8
269 LANGUAGE C IMMUTABLE STRICT
270 AS '$libdir/latlon-v0002', 'pgl_ebox_lon_min';
272 CREATE OR REPLACE FUNCTION max_longitude(ebox)
273 RETURNS float8
274 LANGUAGE C IMMUTABLE STRICT
275 AS '$libdir/latlon-v0002', 'pgl_ebox_lon_max';
277 CREATE OR REPLACE FUNCTION center(ecircle)
278 RETURNS epoint
279 LANGUAGE C IMMUTABLE STRICT
280 AS '$libdir/latlon-v0002', 'pgl_ecircle_center';
282 CREATE OR REPLACE FUNCTION radius(ecircle)
283 RETURNS float8
284 LANGUAGE C IMMUTABLE STRICT
285 AS '$libdir/latlon-v0002', '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-v0002', '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-v0002', '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-v0002', 'pgl_epoint_ecluster_overlap';
302 CREATE OR REPLACE FUNCTION ebox_overlap_proc(ebox, ebox)
303 RETURNS boolean
304 LANGUAGE C IMMUTABLE STRICT
305 AS '$libdir/latlon-v0002', 'pgl_ebox_overlap';
307 CREATE OR REPLACE FUNCTION ecircle_overlap_proc(ecircle, ecircle)
308 RETURNS boolean
309 LANGUAGE C IMMUTABLE STRICT
310 AS '$libdir/latlon-v0002', 'pgl_ecircle_overlap';
312 CREATE OR REPLACE FUNCTION ecircle_ecluster_overlap_proc(ecircle, ecluster)
313 RETURNS boolean
314 LANGUAGE C IMMUTABLE STRICT
315 AS '$libdir/latlon-v0002', 'pgl_ecircle_ecluster_overlap';
317 CREATE OR REPLACE FUNCTION epoint_distance_proc(epoint, epoint)
318 RETURNS float8
319 LANGUAGE C IMMUTABLE STRICT
320 AS '$libdir/latlon-v0002', 'pgl_epoint_distance';
322 CREATE OR REPLACE FUNCTION epoint_ecircle_distance_proc(epoint, ecircle)
323 RETURNS float8
324 LANGUAGE C IMMUTABLE STRICT
325 AS '$libdir/latlon-v0002', 'pgl_epoint_ecircle_distance';
327 CREATE OR REPLACE FUNCTION epoint_ecluster_distance_proc(epoint, ecluster)
328 RETURNS float8
329 LANGUAGE C IMMUTABLE STRICT
330 AS '$libdir/latlon-v0002', 'pgl_epoint_ecluster_distance';
332 CREATE OR REPLACE FUNCTION ecircle_distance_proc(ecircle, ecircle)
333 RETURNS float8
334 LANGUAGE C IMMUTABLE STRICT
335 AS '$libdir/latlon-v0002', 'pgl_ecircle_distance';
337 CREATE OR REPLACE FUNCTION ecircle_ecluster_distance_proc(ecircle, ecluster)
338 RETURNS float8
339 LANGUAGE C IMMUTABLE STRICT
340 AS '$libdir/latlon-v0002', 'pgl_ecircle_ecluster_distance';
342 CREATE OR REPLACE FUNCTION pgl_gist_consistent(internal, internal, smallint, oid, internal)
343 RETURNS boolean
344 LANGUAGE C STRICT
345 AS '$libdir/latlon-v0002', 'pgl_gist_consistent';
347 CREATE OR REPLACE FUNCTION pgl_gist_union(internal, internal)
348 RETURNS internal
349 LANGUAGE C STRICT
350 AS '$libdir/latlon-v0002', 'pgl_gist_union';
352 CREATE OR REPLACE FUNCTION pgl_gist_compress_epoint(internal)
353 RETURNS internal
354 LANGUAGE C STRICT
355 AS '$libdir/latlon-v0002', 'pgl_gist_compress_epoint';
357 CREATE OR REPLACE FUNCTION pgl_gist_compress_ecircle(internal)
358 RETURNS internal
359 LANGUAGE C STRICT
360 AS '$libdir/latlon-v0002', 'pgl_gist_compress_ecircle';
362 CREATE OR REPLACE FUNCTION pgl_gist_compress_ecluster(internal)
363 RETURNS internal
364 LANGUAGE C STRICT
365 AS '$libdir/latlon-v0002', 'pgl_gist_compress_ecluster';
367 CREATE OR REPLACE FUNCTION pgl_gist_decompress(internal)
368 RETURNS internal
369 LANGUAGE C STRICT
370 AS '$libdir/latlon-v0002', 'pgl_gist_decompress';
372 CREATE OR REPLACE FUNCTION pgl_gist_penalty(internal, internal, internal)
373 RETURNS internal
374 LANGUAGE C STRICT
375 AS '$libdir/latlon-v0002', 'pgl_gist_penalty';
377 CREATE OR REPLACE FUNCTION pgl_gist_picksplit(internal, internal)
378 RETURNS internal
379 LANGUAGE C STRICT
380 AS '$libdir/latlon-v0002', 'pgl_gist_picksplit';
382 CREATE OR REPLACE FUNCTION pgl_gist_same(internal, internal, internal)
383 RETURNS internal
384 LANGUAGE C STRICT
385 AS '$libdir/latlon-v0002', 'pgl_gist_same';
387 CREATE OR REPLACE FUNCTION pgl_gist_distance(internal, internal, smallint, oid)
388 RETURNS internal
389 LANGUAGE C STRICT
390 AS '$libdir/latlon-v0002', 'pgl_gist_distance';