pgLatLon
view latlon--0.13--0.14.sql @ 67:9da49e9278ac
Include files for new update path in GNUmakefile
| author | jbe |
|---|---|
| date | Tue Feb 11 02:27:50 2020 +0100 (2020-02-11) |
| parents | 55fab13f2f72 |
| children |
line source
1 DROP OPERATOR CLASS epoint_ops USING gist;
2 DROP OPERATOR CLASS ecluster_ops USING gist;
4 DROP OPERATOR <@ (epoint, ecluster);
6 CREATE OPERATOR <@ (
7 leftarg = epoint,
8 rightarg = ecluster,
9 procedure = epoint_ecluster_overlap_proc,
10 commutator = @>,
11 restrict = areasel,
12 join = areajoinsel
13 );
15 CREATE OPERATOR CLASS epoint_ops
16 DEFAULT FOR TYPE epoint USING gist AS
17 OPERATOR 11 = ,
18 OPERATOR 22 && (epoint, ebox),
19 OPERATOR 222 <@ (epoint, ebox),
20 OPERATOR 23 && (epoint, ecircle),
21 OPERATOR 24 && (epoint, ecluster),
22 OPERATOR 124 &&+ (epoint, ecluster),
23 OPERATOR 224 <@ (epoint, ecluster),
24 OPERATOR 31 <-> (epoint, epoint) FOR ORDER BY float_ops,
25 OPERATOR 32 <-> (epoint, ebox) FOR ORDER BY float_ops,
26 OPERATOR 33 <-> (epoint, ecircle) FOR ORDER BY float_ops,
27 OPERATOR 34 <-> (epoint, ecluster) FOR ORDER BY float_ops,
28 FUNCTION 1 pgl_gist_consistent(internal, internal, smallint, oid, internal),
29 FUNCTION 2 pgl_gist_union(internal, internal),
30 FUNCTION 3 pgl_gist_compress_epoint(internal),
31 FUNCTION 4 pgl_gist_decompress(internal),
32 FUNCTION 5 pgl_gist_penalty(internal, internal, internal),
33 FUNCTION 6 pgl_gist_picksplit(internal, internal),
34 FUNCTION 7 pgl_gist_same(internal, internal, internal),
35 FUNCTION 8 pgl_gist_distance(internal, internal, smallint, oid),
36 STORAGE ekey_point;
38 CREATE OPERATOR CLASS ecluster_ops
39 DEFAULT FOR TYPE ecluster USING gist AS
40 OPERATOR 21 && (ecluster, epoint),
41 OPERATOR 121 &&+ (ecluster, epoint),
42 OPERATOR 221 @> (ecluster, epoint),
43 OPERATOR 22 && (ecluster, ebox),
44 OPERATOR 122 &&+ (ecluster, ebox),
45 OPERATOR 222 @> (ecluster, ebox),
46 OPERATOR 322 <@ (ecluster, ebox),
47 OPERATOR 23 && (ecluster, ecircle),
48 OPERATOR 123 &&+ (ecluster, ecircle),
49 OPERATOR 24 && (ecluster, ecluster),
50 OPERATOR 124 &&+ (ecluster, ecluster),
51 OPERATOR 224 @> (ecluster, ecluster),
52 OPERATOR 324 <@ (ecluster, ecluster),
53 OPERATOR 31 <-> (ecluster, epoint) FOR ORDER BY float_ops,
54 OPERATOR 32 <-> (ecluster, ebox) FOR ORDER BY float_ops,
55 OPERATOR 33 <-> (ecluster, ecircle) FOR ORDER BY float_ops,
56 OPERATOR 34 <-> (ecluster, ecluster) FOR ORDER BY float_ops,
57 OPERATOR 131 <=> (ecluster, epoint_with_sample_count) FOR ORDER BY float_ops,
58 FUNCTION 1 pgl_gist_consistent(internal, internal, smallint, oid, internal),
59 FUNCTION 2 pgl_gist_union(internal, internal),
60 FUNCTION 3 pgl_gist_compress_ecluster(internal),
61 FUNCTION 4 pgl_gist_decompress(internal),
62 FUNCTION 5 pgl_gist_penalty(internal, internal, internal),
63 FUNCTION 6 pgl_gist_picksplit(internal, internal),
64 FUNCTION 7 pgl_gist_same(internal, internal, internal),
65 FUNCTION 8 pgl_gist_distance(internal, internal, smallint, oid),
66 STORAGE ekey_area;