pgLatLon
changeset 66:55fab13f2f72
Changed update path to include version 0.13
author | jbe |
---|---|
date | Tue Feb 11 02:24:06 2020 +0100 (2020-02-11) |
parents | ce0963692318 |
children | 9da49e9278ac |
files | latlon--0.12--0.13.sql latlon--0.12--0.14.sql latlon--0.13--0.14.sql |
line diff
1.1 --- /dev/null Thu Jan 01 00:00:00 1970 +0000 1.2 +++ b/latlon--0.12--0.13.sql Tue Feb 11 02:24:06 2020 +0100 1.3 @@ -0,0 +1,2 @@ 1.4 +-- Nothing to do here, as version 0.13 only contained compatibility changes to 1.5 +-- allow compilation with recent PostgreSQL versions.
2.1 --- a/latlon--0.12--0.14.sql Tue Feb 11 02:18:16 2020 +0100 2.2 +++ /dev/null Thu Jan 01 00:00:00 1970 +0000 2.3 @@ -1,67 +0,0 @@ 2.4 -DROP OPERATOR CLASS epoint_ops USING gist; 2.5 -DROP OPERATOR CLASS ecluster_ops USING gist; 2.6 - 2.7 -DROP OPERATOR <@ (epoint, ecluster); 2.8 - 2.9 -CREATE OPERATOR <@ ( 2.10 - leftarg = epoint, 2.11 - rightarg = ecluster, 2.12 - procedure = epoint_ecluster_overlap_proc, 2.13 - commutator = @>, 2.14 - restrict = areasel, 2.15 - join = areajoinsel 2.16 -); 2.17 - 2.18 -CREATE OPERATOR CLASS epoint_ops 2.19 - DEFAULT FOR TYPE epoint USING gist AS 2.20 - OPERATOR 11 = , 2.21 - OPERATOR 22 && (epoint, ebox), 2.22 - OPERATOR 222 <@ (epoint, ebox), 2.23 - OPERATOR 23 && (epoint, ecircle), 2.24 - OPERATOR 24 && (epoint, ecluster), 2.25 - OPERATOR 124 &&+ (epoint, ecluster), 2.26 - OPERATOR 224 <@ (epoint, ecluster), 2.27 - OPERATOR 31 <-> (epoint, epoint) FOR ORDER BY float_ops, 2.28 - OPERATOR 32 <-> (epoint, ebox) FOR ORDER BY float_ops, 2.29 - OPERATOR 33 <-> (epoint, ecircle) FOR ORDER BY float_ops, 2.30 - OPERATOR 34 <-> (epoint, ecluster) FOR ORDER BY float_ops, 2.31 - FUNCTION 1 pgl_gist_consistent(internal, internal, smallint, oid, internal), 2.32 - FUNCTION 2 pgl_gist_union(internal, internal), 2.33 - FUNCTION 3 pgl_gist_compress_epoint(internal), 2.34 - FUNCTION 4 pgl_gist_decompress(internal), 2.35 - FUNCTION 5 pgl_gist_penalty(internal, internal, internal), 2.36 - FUNCTION 6 pgl_gist_picksplit(internal, internal), 2.37 - FUNCTION 7 pgl_gist_same(internal, internal, internal), 2.38 - FUNCTION 8 pgl_gist_distance(internal, internal, smallint, oid), 2.39 - STORAGE ekey_point; 2.40 - 2.41 -CREATE OPERATOR CLASS ecluster_ops 2.42 - DEFAULT FOR TYPE ecluster USING gist AS 2.43 - OPERATOR 21 && (ecluster, epoint), 2.44 - OPERATOR 121 &&+ (ecluster, epoint), 2.45 - OPERATOR 221 @> (ecluster, epoint), 2.46 - OPERATOR 22 && (ecluster, ebox), 2.47 - OPERATOR 122 &&+ (ecluster, ebox), 2.48 - OPERATOR 222 @> (ecluster, ebox), 2.49 - OPERATOR 322 <@ (ecluster, ebox), 2.50 - OPERATOR 23 && (ecluster, ecircle), 2.51 - OPERATOR 123 &&+ (ecluster, ecircle), 2.52 - OPERATOR 24 && (ecluster, ecluster), 2.53 - OPERATOR 124 &&+ (ecluster, ecluster), 2.54 - OPERATOR 224 @> (ecluster, ecluster), 2.55 - OPERATOR 324 <@ (ecluster, ecluster), 2.56 - OPERATOR 31 <-> (ecluster, epoint) FOR ORDER BY float_ops, 2.57 - OPERATOR 32 <-> (ecluster, ebox) FOR ORDER BY float_ops, 2.58 - OPERATOR 33 <-> (ecluster, ecircle) FOR ORDER BY float_ops, 2.59 - OPERATOR 34 <-> (ecluster, ecluster) FOR ORDER BY float_ops, 2.60 - OPERATOR 131 <=> (ecluster, epoint_with_sample_count) FOR ORDER BY float_ops, 2.61 - FUNCTION 1 pgl_gist_consistent(internal, internal, smallint, oid, internal), 2.62 - FUNCTION 2 pgl_gist_union(internal, internal), 2.63 - FUNCTION 3 pgl_gist_compress_ecluster(internal), 2.64 - FUNCTION 4 pgl_gist_decompress(internal), 2.65 - FUNCTION 5 pgl_gist_penalty(internal, internal, internal), 2.66 - FUNCTION 6 pgl_gist_picksplit(internal, internal), 2.67 - FUNCTION 7 pgl_gist_same(internal, internal, internal), 2.68 - FUNCTION 8 pgl_gist_distance(internal, internal, smallint, oid), 2.69 - STORAGE ekey_area; 2.70 -
3.1 --- /dev/null Thu Jan 01 00:00:00 1970 +0000 3.2 +++ b/latlon--0.13--0.14.sql Tue Feb 11 02:24:06 2020 +0100 3.3 @@ -0,0 +1,67 @@ 3.4 +DROP OPERATOR CLASS epoint_ops USING gist; 3.5 +DROP OPERATOR CLASS ecluster_ops USING gist; 3.6 + 3.7 +DROP OPERATOR <@ (epoint, ecluster); 3.8 + 3.9 +CREATE OPERATOR <@ ( 3.10 + leftarg = epoint, 3.11 + rightarg = ecluster, 3.12 + procedure = epoint_ecluster_overlap_proc, 3.13 + commutator = @>, 3.14 + restrict = areasel, 3.15 + join = areajoinsel 3.16 +); 3.17 + 3.18 +CREATE OPERATOR CLASS epoint_ops 3.19 + DEFAULT FOR TYPE epoint USING gist AS 3.20 + OPERATOR 11 = , 3.21 + OPERATOR 22 && (epoint, ebox), 3.22 + OPERATOR 222 <@ (epoint, ebox), 3.23 + OPERATOR 23 && (epoint, ecircle), 3.24 + OPERATOR 24 && (epoint, ecluster), 3.25 + OPERATOR 124 &&+ (epoint, ecluster), 3.26 + OPERATOR 224 <@ (epoint, ecluster), 3.27 + OPERATOR 31 <-> (epoint, epoint) FOR ORDER BY float_ops, 3.28 + OPERATOR 32 <-> (epoint, ebox) FOR ORDER BY float_ops, 3.29 + OPERATOR 33 <-> (epoint, ecircle) FOR ORDER BY float_ops, 3.30 + OPERATOR 34 <-> (epoint, ecluster) FOR ORDER BY float_ops, 3.31 + FUNCTION 1 pgl_gist_consistent(internal, internal, smallint, oid, internal), 3.32 + FUNCTION 2 pgl_gist_union(internal, internal), 3.33 + FUNCTION 3 pgl_gist_compress_epoint(internal), 3.34 + FUNCTION 4 pgl_gist_decompress(internal), 3.35 + FUNCTION 5 pgl_gist_penalty(internal, internal, internal), 3.36 + FUNCTION 6 pgl_gist_picksplit(internal, internal), 3.37 + FUNCTION 7 pgl_gist_same(internal, internal, internal), 3.38 + FUNCTION 8 pgl_gist_distance(internal, internal, smallint, oid), 3.39 + STORAGE ekey_point; 3.40 + 3.41 +CREATE OPERATOR CLASS ecluster_ops 3.42 + DEFAULT FOR TYPE ecluster USING gist AS 3.43 + OPERATOR 21 && (ecluster, epoint), 3.44 + OPERATOR 121 &&+ (ecluster, epoint), 3.45 + OPERATOR 221 @> (ecluster, epoint), 3.46 + OPERATOR 22 && (ecluster, ebox), 3.47 + OPERATOR 122 &&+ (ecluster, ebox), 3.48 + OPERATOR 222 @> (ecluster, ebox), 3.49 + OPERATOR 322 <@ (ecluster, ebox), 3.50 + OPERATOR 23 && (ecluster, ecircle), 3.51 + OPERATOR 123 &&+ (ecluster, ecircle), 3.52 + OPERATOR 24 && (ecluster, ecluster), 3.53 + OPERATOR 124 &&+ (ecluster, ecluster), 3.54 + OPERATOR 224 @> (ecluster, ecluster), 3.55 + OPERATOR 324 <@ (ecluster, ecluster), 3.56 + OPERATOR 31 <-> (ecluster, epoint) FOR ORDER BY float_ops, 3.57 + OPERATOR 32 <-> (ecluster, ebox) FOR ORDER BY float_ops, 3.58 + OPERATOR 33 <-> (ecluster, ecircle) FOR ORDER BY float_ops, 3.59 + OPERATOR 34 <-> (ecluster, ecluster) FOR ORDER BY float_ops, 3.60 + OPERATOR 131 <=> (ecluster, epoint_with_sample_count) FOR ORDER BY float_ops, 3.61 + FUNCTION 1 pgl_gist_consistent(internal, internal, smallint, oid, internal), 3.62 + FUNCTION 2 pgl_gist_union(internal, internal), 3.63 + FUNCTION 3 pgl_gist_compress_ecluster(internal), 3.64 + FUNCTION 4 pgl_gist_decompress(internal), 3.65 + FUNCTION 5 pgl_gist_penalty(internal, internal, internal), 3.66 + FUNCTION 6 pgl_gist_picksplit(internal, internal), 3.67 + FUNCTION 7 pgl_gist_same(internal, internal, internal), 3.68 + FUNCTION 8 pgl_gist_distance(internal, internal, smallint, oid), 3.69 + STORAGE ekey_area; 3.70 +