pgLatLon
view latlon--0.9--0.10.sql @ 49:b37a0dc6d1ec
Minor fix in documentation regarding GeoJSON_to_ecluster function for GeoJSON indexing
| author | jbe |
|---|---|
| date | Thu Sep 28 02:10:21 2017 +0200 (2017-09-28) |
| parents | 3cbce515387f |
| children |
line source
2 CREATE TYPE epoint_with_sample_count;
4 CREATE OR REPLACE FUNCTION ekey_point_in_dummy(cstring)
5 RETURNS ekey_point
6 LANGUAGE C IMMUTABLE STRICT
7 AS '$libdir/latlon-v0009', 'pgl_notimpl';
9 CREATE OR REPLACE FUNCTION ekey_point_out_dummy(ekey_point)
10 RETURNS cstring
11 LANGUAGE C IMMUTABLE STRICT
12 AS '$libdir/latlon-v0009', 'pgl_notimpl';
14 CREATE OR REPLACE FUNCTION ekey_area_in_dummy(cstring)
15 RETURNS ekey_area
16 LANGUAGE C IMMUTABLE STRICT
17 AS '$libdir/latlon-v0009', 'pgl_notimpl';
19 CREATE OR REPLACE FUNCTION ekey_area_out_dummy(ekey_area)
20 RETURNS cstring
21 LANGUAGE C IMMUTABLE STRICT
22 AS '$libdir/latlon-v0009', 'pgl_notimpl';
24 CREATE OR REPLACE FUNCTION epoint_in(cstring)
25 RETURNS epoint
26 LANGUAGE C IMMUTABLE STRICT
27 AS '$libdir/latlon-v0009', 'pgl_epoint_in';
29 CREATE FUNCTION epoint_with_sample_count_in(cstring)
30 RETURNS epoint_with_sample_count
31 LANGUAGE C IMMUTABLE STRICT
32 AS '$libdir/latlon-v0009', 'pgl_epoint_with_sample_count_in';
34 CREATE OR REPLACE FUNCTION ebox_in(cstring)
35 RETURNS ebox
36 LANGUAGE C IMMUTABLE STRICT
37 AS '$libdir/latlon-v0009', 'pgl_ebox_in';
39 CREATE OR REPLACE FUNCTION ecircle_in(cstring)
40 RETURNS ecircle
41 LANGUAGE C IMMUTABLE STRICT
42 AS '$libdir/latlon-v0009', 'pgl_ecircle_in';
44 CREATE OR REPLACE FUNCTION ecluster_in(cstring)
45 RETURNS ecluster
46 LANGUAGE C IMMUTABLE STRICT
47 AS '$libdir/latlon-v0009', 'pgl_ecluster_in';
49 CREATE OR REPLACE FUNCTION epoint_out(epoint)
50 RETURNS cstring
51 LANGUAGE C IMMUTABLE STRICT
52 AS '$libdir/latlon-v0009', 'pgl_epoint_out';
54 CREATE FUNCTION epoint_with_sample_count_out(epoint_with_sample_count)
55 RETURNS cstring
56 LANGUAGE C IMMUTABLE STRICT
57 AS '$libdir/latlon-v0009', 'pgl_epoint_with_sample_count_out';
59 CREATE OR REPLACE FUNCTION ebox_out(ebox)
60 RETURNS cstring
61 LANGUAGE C IMMUTABLE STRICT
62 AS '$libdir/latlon-v0009', 'pgl_ebox_out';
64 CREATE OR REPLACE FUNCTION ecircle_out(ecircle)
65 RETURNS cstring
66 LANGUAGE C IMMUTABLE STRICT
67 AS '$libdir/latlon-v0009', 'pgl_ecircle_out';
69 CREATE OR REPLACE FUNCTION ecluster_out(ecluster)
70 RETURNS cstring
71 LANGUAGE C IMMUTABLE STRICT
72 AS '$libdir/latlon-v0009', 'pgl_ecluster_out';
74 CREATE OR REPLACE FUNCTION epoint_recv(internal)
75 RETURNS epoint
76 LANGUAGE C IMMUTABLE STRICT
77 AS '$libdir/latlon-v0009', 'pgl_epoint_recv';
79 CREATE OR REPLACE FUNCTION ebox_recv(internal)
80 RETURNS ebox
81 LANGUAGE C IMMUTABLE STRICT
82 AS '$libdir/latlon-v0009', 'pgl_ebox_recv';
84 CREATE OR REPLACE FUNCTION ecircle_recv(internal)
85 RETURNS ecircle
86 LANGUAGE C IMMUTABLE STRICT
87 AS '$libdir/latlon-v0009', 'pgl_ecircle_recv';
89 CREATE OR REPLACE FUNCTION epoint_send(epoint)
90 RETURNS bytea
91 LANGUAGE C IMMUTABLE STRICT
92 AS '$libdir/latlon-v0009', 'pgl_epoint_send';
94 CREATE OR REPLACE FUNCTION ebox_send(ebox)
95 RETURNS bytea
96 LANGUAGE C IMMUTABLE STRICT
97 AS '$libdir/latlon-v0009', 'pgl_ebox_send';
99 CREATE OR REPLACE FUNCTION ecircle_send(ecircle)
100 RETURNS bytea
101 LANGUAGE C IMMUTABLE STRICT
102 AS '$libdir/latlon-v0009', 'pgl_ecircle_send';
104 CREATE TYPE epoint_with_sample_count (
105 internallength = 20,
106 input = epoint_with_sample_count_in,
107 output = epoint_with_sample_count_out,
108 alignment = double );
110 CREATE OR REPLACE FUNCTION epoint_btree_lt(epoint, epoint)
111 RETURNS boolean
112 LANGUAGE C IMMUTABLE STRICT
113 AS '$libdir/latlon-v0009', 'pgl_btree_epoint_lt';
115 CREATE OR REPLACE FUNCTION epoint_btree_le(epoint, epoint)
116 RETURNS boolean
117 LANGUAGE C IMMUTABLE STRICT
118 AS '$libdir/latlon-v0009', 'pgl_btree_epoint_le';
120 CREATE OR REPLACE FUNCTION epoint_btree_eq(epoint, epoint)
121 RETURNS boolean
122 LANGUAGE C IMMUTABLE STRICT
123 AS '$libdir/latlon-v0009', 'pgl_btree_epoint_eq';
125 CREATE OR REPLACE FUNCTION epoint_btree_ne(epoint, epoint)
126 RETURNS boolean
127 LANGUAGE C IMMUTABLE STRICT
128 AS '$libdir/latlon-v0009', 'pgl_btree_epoint_ne';
130 CREATE OR REPLACE FUNCTION epoint_btree_ge(epoint, epoint)
131 RETURNS boolean
132 LANGUAGE C IMMUTABLE STRICT
133 AS '$libdir/latlon-v0009', 'pgl_btree_epoint_ge';
135 CREATE OR REPLACE FUNCTION epoint_btree_gt(epoint, epoint)
136 RETURNS boolean
137 LANGUAGE C IMMUTABLE STRICT
138 AS '$libdir/latlon-v0009', 'pgl_btree_epoint_gt';
140 CREATE OR REPLACE FUNCTION epoint_btree_cmp(epoint, epoint)
141 RETURNS int4
142 LANGUAGE C IMMUTABLE STRICT
143 AS '$libdir/latlon-v0009', 'pgl_btree_epoint_cmp';
145 CREATE OR REPLACE FUNCTION ebox_btree_lt(ebox, ebox)
146 RETURNS boolean
147 LANGUAGE C IMMUTABLE STRICT
148 AS '$libdir/latlon-v0009', 'pgl_btree_ebox_lt';
150 CREATE OR REPLACE FUNCTION ebox_btree_le(ebox, ebox)
151 RETURNS boolean
152 LANGUAGE C IMMUTABLE STRICT
153 AS '$libdir/latlon-v0009', 'pgl_btree_ebox_le';
155 CREATE OR REPLACE FUNCTION ebox_btree_eq(ebox, ebox)
156 RETURNS boolean
157 LANGUAGE C IMMUTABLE STRICT
158 AS '$libdir/latlon-v0009', 'pgl_btree_ebox_eq';
160 CREATE OR REPLACE FUNCTION ebox_btree_ne(ebox, ebox)
161 RETURNS boolean
162 LANGUAGE C IMMUTABLE STRICT
163 AS '$libdir/latlon-v0009', 'pgl_btree_ebox_ne';
165 CREATE OR REPLACE FUNCTION ebox_btree_ge(ebox, ebox)
166 RETURNS boolean
167 LANGUAGE C IMMUTABLE STRICT
168 AS '$libdir/latlon-v0009', 'pgl_btree_ebox_ge';
170 CREATE OR REPLACE FUNCTION ebox_btree_gt(ebox, ebox)
171 RETURNS boolean
172 LANGUAGE C IMMUTABLE STRICT
173 AS '$libdir/latlon-v0009', 'pgl_btree_ebox_gt';
175 CREATE OR REPLACE FUNCTION ebox_btree_cmp(ebox, ebox)
176 RETURNS int4
177 LANGUAGE C IMMUTABLE STRICT
178 AS '$libdir/latlon-v0009', 'pgl_btree_ebox_cmp';
180 CREATE OR REPLACE FUNCTION ecircle_btree_lt(ecircle, ecircle)
181 RETURNS boolean
182 LANGUAGE C IMMUTABLE STRICT
183 AS '$libdir/latlon-v0009', 'pgl_btree_ecircle_lt';
185 CREATE OR REPLACE FUNCTION ecircle_btree_le(ecircle, ecircle)
186 RETURNS boolean
187 LANGUAGE C IMMUTABLE STRICT
188 AS '$libdir/latlon-v0009', 'pgl_btree_ecircle_le';
190 CREATE OR REPLACE FUNCTION ecircle_btree_eq(ecircle, ecircle)
191 RETURNS boolean
192 LANGUAGE C IMMUTABLE STRICT
193 AS '$libdir/latlon-v0009', 'pgl_btree_ecircle_eq';
195 CREATE OR REPLACE FUNCTION ecircle_btree_ne(ecircle, ecircle)
196 RETURNS boolean
197 LANGUAGE C IMMUTABLE STRICT
198 AS '$libdir/latlon-v0009', 'pgl_btree_ecircle_ne';
200 CREATE OR REPLACE FUNCTION ecircle_btree_ge(ecircle, ecircle)
201 RETURNS boolean
202 LANGUAGE C IMMUTABLE STRICT
203 AS '$libdir/latlon-v0009', 'pgl_btree_ecircle_ge';
205 CREATE OR REPLACE FUNCTION ecircle_btree_gt(ecircle, ecircle)
206 RETURNS boolean
207 LANGUAGE C IMMUTABLE STRICT
208 AS '$libdir/latlon-v0009', 'pgl_btree_ecircle_gt';
210 CREATE OR REPLACE FUNCTION ecircle_btree_cmp(ecircle, ecircle)
211 RETURNS int4
212 LANGUAGE C IMMUTABLE STRICT
213 AS '$libdir/latlon-v0009', 'pgl_btree_ecircle_cmp';
215 CREATE OR REPLACE FUNCTION cast_epoint_to_ebox(epoint)
216 RETURNS ebox
217 LANGUAGE C IMMUTABLE STRICT
218 AS '$libdir/latlon-v0009', 'pgl_epoint_to_ebox';
220 CREATE OR REPLACE FUNCTION cast_epoint_to_ecircle(epoint)
221 RETURNS ecircle
222 LANGUAGE C IMMUTABLE STRICT
223 AS '$libdir/latlon-v0009', 'pgl_epoint_to_ecircle';
225 CREATE OR REPLACE FUNCTION cast_epoint_to_ecluster(epoint)
226 RETURNS ecluster
227 LANGUAGE C IMMUTABLE STRICT
228 AS '$libdir/latlon-v0009', 'pgl_epoint_to_ecluster';
230 CREATE OR REPLACE FUNCTION cast_ebox_to_ecluster(ebox)
231 RETURNS ecluster
232 LANGUAGE C IMMUTABLE STRICT
233 AS '$libdir/latlon-v0009', 'pgl_ebox_to_ecluster';
235 CREATE OR REPLACE FUNCTION epoint(float8, float8)
236 RETURNS epoint
237 LANGUAGE C IMMUTABLE STRICT
238 AS '$libdir/latlon-v0009', 'pgl_create_epoint';
240 CREATE FUNCTION epoint_with_sample_count(epoint, int4)
241 RETURNS epoint_with_sample_count
242 LANGUAGE C IMMUTABLE STRICT
243 AS '$libdir/latlon-v0009', 'pgl_create_epoint_with_sample_count';
245 CREATE OR REPLACE FUNCTION empty_ebox()
246 RETURNS ebox
247 LANGUAGE C IMMUTABLE STRICT
248 AS '$libdir/latlon-v0009', 'pgl_create_empty_ebox';
250 CREATE OR REPLACE FUNCTION ebox(float8, float8, float8, float8)
251 RETURNS ebox
252 LANGUAGE C IMMUTABLE STRICT
253 AS '$libdir/latlon-v0009', 'pgl_create_ebox';
255 CREATE OR REPLACE FUNCTION ebox(epoint, epoint)
256 RETURNS ebox
257 LANGUAGE C IMMUTABLE STRICT
258 AS '$libdir/latlon-v0009', 'pgl_create_ebox_from_epoints';
260 CREATE OR REPLACE FUNCTION ecircle(float8, float8, float8)
261 RETURNS ecircle
262 LANGUAGE C IMMUTABLE STRICT
263 AS '$libdir/latlon-v0009', 'pgl_create_ecircle';
265 CREATE OR REPLACE FUNCTION ecircle(epoint, float8)
266 RETURNS ecircle
267 LANGUAGE C IMMUTABLE STRICT
268 AS '$libdir/latlon-v0009', 'pgl_create_ecircle_from_epoint';
270 CREATE OR REPLACE FUNCTION latitude(epoint)
271 RETURNS float8
272 LANGUAGE C IMMUTABLE STRICT
273 AS '$libdir/latlon-v0009', 'pgl_epoint_lat';
275 CREATE OR REPLACE FUNCTION longitude(epoint)
276 RETURNS float8
277 LANGUAGE C IMMUTABLE STRICT
278 AS '$libdir/latlon-v0009', 'pgl_epoint_lon';
280 CREATE OR REPLACE FUNCTION min_latitude(ebox)
281 RETURNS float8
282 LANGUAGE C IMMUTABLE STRICT
283 AS '$libdir/latlon-v0009', 'pgl_ebox_lat_min';
285 CREATE OR REPLACE FUNCTION max_latitude(ebox)
286 RETURNS float8
287 LANGUAGE C IMMUTABLE STRICT
288 AS '$libdir/latlon-v0009', 'pgl_ebox_lat_max';
290 CREATE OR REPLACE FUNCTION min_longitude(ebox)
291 RETURNS float8
292 LANGUAGE C IMMUTABLE STRICT
293 AS '$libdir/latlon-v0009', 'pgl_ebox_lon_min';
295 CREATE OR REPLACE FUNCTION max_longitude(ebox)
296 RETURNS float8
297 LANGUAGE C IMMUTABLE STRICT
298 AS '$libdir/latlon-v0009', 'pgl_ebox_lon_max';
300 CREATE OR REPLACE FUNCTION center(ecircle)
301 RETURNS epoint
302 LANGUAGE C IMMUTABLE STRICT
303 AS '$libdir/latlon-v0009', 'pgl_ecircle_center';
305 CREATE OR REPLACE FUNCTION radius(ecircle)
306 RETURNS float8
307 LANGUAGE C IMMUTABLE STRICT
308 AS '$libdir/latlon-v0009', 'pgl_ecircle_radius';
310 CREATE OR REPLACE FUNCTION epoint_ebox_overlap_proc(epoint, ebox)
311 RETURNS boolean
312 LANGUAGE C IMMUTABLE STRICT
313 AS '$libdir/latlon-v0009', 'pgl_epoint_ebox_overlap';
315 CREATE OR REPLACE FUNCTION epoint_ecircle_overlap_proc(epoint, ecircle)
316 RETURNS boolean
317 LANGUAGE C IMMUTABLE STRICT
318 AS '$libdir/latlon-v0009', 'pgl_epoint_ecircle_overlap';
320 CREATE OR REPLACE FUNCTION epoint_ecluster_overlap_proc(epoint, ecluster)
321 RETURNS boolean
322 LANGUAGE C IMMUTABLE STRICT
323 AS '$libdir/latlon-v0009', 'pgl_epoint_ecluster_overlap';
325 CREATE OR REPLACE FUNCTION epoint_ecluster_may_overlap_proc(epoint, ecluster)
326 RETURNS boolean
327 LANGUAGE C IMMUTABLE STRICT
328 AS '$libdir/latlon-v0009', 'pgl_epoint_ecluster_may_overlap';
330 CREATE OR REPLACE FUNCTION ebox_overlap_proc(ebox, ebox)
331 RETURNS boolean
332 LANGUAGE C IMMUTABLE STRICT
333 AS '$libdir/latlon-v0009', 'pgl_ebox_overlap';
335 CREATE OR REPLACE FUNCTION ebox_ecircle_may_overlap_proc(ebox, ecircle)
336 RETURNS boolean
337 LANGUAGE C IMMUTABLE STRICT
338 AS '$libdir/latlon-v0009', 'pgl_ebox_ecircle_may_overlap';
340 CREATE OR REPLACE FUNCTION ebox_ecluster_may_overlap_proc(ebox, ecluster)
341 RETURNS boolean
342 LANGUAGE C IMMUTABLE STRICT
343 AS '$libdir/latlon-v0009', 'pgl_ebox_ecluster_may_overlap';
345 CREATE OR REPLACE FUNCTION ecircle_overlap_proc(ecircle, ecircle)
346 RETURNS boolean
347 LANGUAGE C IMMUTABLE STRICT
348 AS '$libdir/latlon-v0009', 'pgl_ecircle_overlap';
350 CREATE OR REPLACE FUNCTION ecircle_ecluster_overlap_proc(ecircle, ecluster)
351 RETURNS boolean
352 LANGUAGE C IMMUTABLE STRICT
353 AS '$libdir/latlon-v0009', 'pgl_ecircle_ecluster_overlap';
355 CREATE OR REPLACE FUNCTION ecircle_ecluster_may_overlap_proc(ecircle, ecluster)
356 RETURNS boolean
357 LANGUAGE C IMMUTABLE STRICT
358 AS '$libdir/latlon-v0009', 'pgl_ecircle_ecluster_may_overlap';
360 CREATE OR REPLACE FUNCTION ecluster_overlap_proc(ecluster, ecluster)
361 RETURNS boolean
362 LANGUAGE C IMMUTABLE STRICT
363 AS '$libdir/latlon-v0009', 'pgl_ecluster_overlap';
365 CREATE OR REPLACE FUNCTION ecluster_may_overlap_proc(ecluster, ecluster)
366 RETURNS boolean
367 LANGUAGE C IMMUTABLE STRICT
368 AS '$libdir/latlon-v0009', 'pgl_ecluster_may_overlap';
370 CREATE OR REPLACE FUNCTION ecluster_contains_proc(ecluster, ecluster)
371 RETURNS boolean
372 LANGUAGE C IMMUTABLE STRICT
373 AS '$libdir/latlon-v0009', 'pgl_ecluster_contains';
375 CREATE OR REPLACE FUNCTION epoint_distance_proc(epoint, epoint)
376 RETURNS float8
377 LANGUAGE C IMMUTABLE STRICT
378 AS '$libdir/latlon-v0009', 'pgl_epoint_distance';
380 CREATE OR REPLACE FUNCTION epoint_ecircle_distance_proc(epoint, ecircle)
381 RETURNS float8
382 LANGUAGE C IMMUTABLE STRICT
383 AS '$libdir/latlon-v0009', 'pgl_epoint_ecircle_distance';
385 CREATE OR REPLACE FUNCTION epoint_ecluster_distance_proc(epoint, ecluster)
386 RETURNS float8
387 LANGUAGE C IMMUTABLE STRICT
388 AS '$libdir/latlon-v0009', 'pgl_epoint_ecluster_distance';
390 CREATE OR REPLACE FUNCTION ecircle_distance_proc(ecircle, ecircle)
391 RETURNS float8
392 LANGUAGE C IMMUTABLE STRICT
393 AS '$libdir/latlon-v0009', 'pgl_ecircle_distance';
395 CREATE OR REPLACE FUNCTION ecircle_ecluster_distance_proc(ecircle, ecluster)
396 RETURNS float8
397 LANGUAGE C IMMUTABLE STRICT
398 AS '$libdir/latlon-v0009', 'pgl_ecircle_ecluster_distance';
400 CREATE OR REPLACE FUNCTION ecluster_distance_proc(ecluster, ecluster)
401 RETURNS float8
402 LANGUAGE C IMMUTABLE STRICT
403 AS '$libdir/latlon-v0009', 'pgl_ecluster_distance';
405 DROP FUNCTION monte_carlo_area(ecluster, int4);
407 CREATE FUNCTION fair_distance_operator_proc(ecluster, epoint_with_sample_count)
408 RETURNS float8
409 LANGUAGE C IMMUTABLE STRICT
410 AS '$libdir/latlon-v0009', 'pgl_ecluster_epoint_sc_fair_distance';
412 CREATE OPERATOR <=> (
413 leftarg = ecluster,
414 rightarg = epoint_with_sample_count,
415 procedure = fair_distance_operator_proc
416 );
418 CREATE OR REPLACE FUNCTION pgl_gist_consistent(internal, internal, smallint, oid, internal)
419 RETURNS boolean
420 LANGUAGE C STRICT
421 AS '$libdir/latlon-v0009', 'pgl_gist_consistent';
423 CREATE OR REPLACE FUNCTION pgl_gist_union(internal, internal)
424 RETURNS internal
425 LANGUAGE C STRICT
426 AS '$libdir/latlon-v0009', 'pgl_gist_union';
428 CREATE OR REPLACE FUNCTION pgl_gist_compress_epoint(internal)
429 RETURNS internal
430 LANGUAGE C STRICT
431 AS '$libdir/latlon-v0009', 'pgl_gist_compress_epoint';
433 CREATE OR REPLACE FUNCTION pgl_gist_compress_ecircle(internal)
434 RETURNS internal
435 LANGUAGE C STRICT
436 AS '$libdir/latlon-v0009', 'pgl_gist_compress_ecircle';
438 CREATE OR REPLACE FUNCTION pgl_gist_compress_ecluster(internal)
439 RETURNS internal
440 LANGUAGE C STRICT
441 AS '$libdir/latlon-v0009', 'pgl_gist_compress_ecluster';
443 CREATE OR REPLACE FUNCTION pgl_gist_decompress(internal)
444 RETURNS internal
445 LANGUAGE C STRICT
446 AS '$libdir/latlon-v0009', 'pgl_gist_decompress';
448 CREATE OR REPLACE FUNCTION pgl_gist_penalty(internal, internal, internal)
449 RETURNS internal
450 LANGUAGE C STRICT
451 AS '$libdir/latlon-v0009', 'pgl_gist_penalty';
453 CREATE OR REPLACE FUNCTION pgl_gist_picksplit(internal, internal)
454 RETURNS internal
455 LANGUAGE C STRICT
456 AS '$libdir/latlon-v0009', 'pgl_gist_picksplit';
458 CREATE OR REPLACE FUNCTION pgl_gist_same(internal, internal, internal)
459 RETURNS internal
460 LANGUAGE C STRICT
461 AS '$libdir/latlon-v0009', 'pgl_gist_same';
463 CREATE OR REPLACE FUNCTION pgl_gist_distance(internal, internal, smallint, oid)
464 RETURNS internal
465 LANGUAGE C STRICT
466 AS '$libdir/latlon-v0009', 'pgl_gist_distance';
468 DROP OPERATOR CLASS ecluster_ops USING gist;
470 CREATE OPERATOR CLASS ecluster_ops
471 DEFAULT FOR TYPE ecluster USING gist AS
472 OPERATOR 21 && (ecluster, epoint),
473 OPERATOR 121 &&+ (ecluster, epoint),
474 OPERATOR 221 @> (ecluster, epoint),
475 OPERATOR 22 && (ecluster, ebox),
476 OPERATOR 122 &&+ (ecluster, ebox),
477 OPERATOR 222 @> (ecluster, ebox),
478 OPERATOR 322 <@ (ecluster, ebox),
479 OPERATOR 23 && (ecluster, ecircle),
480 OPERATOR 123 &&+ (ecluster, ecircle),
481 OPERATOR 24 && (ecluster, ecluster),
482 OPERATOR 124 &&+ (ecluster, ecluster),
483 OPERATOR 224 @> (ecluster, ecluster),
484 OPERATOR 324 <@ (ecluster, ecluster),
485 OPERATOR 31 <-> (ecluster, epoint) FOR ORDER BY float_ops,
486 OPERATOR 32 <-> (ecluster, ebox) FOR ORDER BY float_ops,
487 OPERATOR 33 <-> (ecluster, ecircle) FOR ORDER BY float_ops,
488 OPERATOR 34 <-> (ecluster, ecluster) FOR ORDER BY float_ops,
489 OPERATOR 131 <=> (ecluster, epoint_with_sample_count) FOR ORDER BY float_ops,
490 FUNCTION 1 pgl_gist_consistent(internal, internal, smallint, oid, internal),
491 FUNCTION 2 pgl_gist_union(internal, internal),
492 FUNCTION 3 pgl_gist_compress_ecluster(internal),
493 FUNCTION 4 pgl_gist_decompress(internal),
494 FUNCTION 5 pgl_gist_penalty(internal, internal, internal),
495 FUNCTION 6 pgl_gist_picksplit(internal, internal),
496 FUNCTION 7 pgl_gist_same(internal, internal, internal),
497 FUNCTION 8 pgl_gist_distance(internal, internal, smallint, oid),
498 STORAGE ekey_area;
500 CREATE OR REPLACE FUNCTION fair_distance(ecluster, epoint, int4 = 10000)
501 RETURNS float8
502 LANGUAGE sql IMMUTABLE AS 'SELECT $1 <=> epoint_with_sample_count($2, $3)';