pgLatLon

changeset 66:55fab13f2f72

Changed update path to include version 0.13
author jbe
date Tue Feb 11 02:24:06 2020 +0100 (7 weeks ago)
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 +

Impressum / About Us