pgLatLon

changeset 75:1cdb3da50176

Bugfix regarding schema installation in GeoJSON_to_ecluster function
author jbe
date Mon Nov 30 18:50:48 2020 +0100 (2020-11-30)
parents 76b3fd3293fc
children 4f11ccf36fb6
files latlon--0.14--0.15.sql latlon--0.15.sql
line diff
     1.1 --- a/latlon--0.14--0.15.sql	Mon Nov 30 17:25:32 2020 +0100
     1.2 +++ b/latlon--0.14--0.15.sql	Mon Nov 30 18:50:48 2020 +0100
     1.3 @@ -921,7 +921,7 @@
     1.4      WHEN 'MultiLineString' THEN
     1.5        ( SELECT @extschema@.ecluster_concat(pg_catalog.array_agg(
     1.6            ( SELECT @extschema@.ecluster_create_path(pg_catalog.array_agg(
     1.7 -              coords_to_epoint(
     1.8 +              @extschema@.coords_to_epoint(
     1.9                  ("coord" OPERATOR(pg_catalog.->>) 0)::pg_catalog.float8,
    1.10                  ("coord" OPERATOR(pg_catalog.->>) 1)::pg_catalog.float8,
    1.11                  $2
    1.12 @@ -954,13 +954,15 @@
    1.13      WHEN 'MultiPolygon' THEN
    1.14        ( SELECT @extschema@.ecluster_concat(pg_catalog.array_agg(
    1.15            ( SELECT @extschema@.ecluster_concat(pg_catalog.array_agg(
    1.16 -              ( SELECT pg_catalog.ecluster_create_polygon(pg_catalog.array_agg(
    1.17 -                  @extschema@.coords_to_epoint(
    1.18 -                    ("coord" OPERATOR(pg_catalog.->>) 0)::pg_catalog.float8,
    1.19 -                    ("coord" OPERATOR(pg_catalog.->>) 1)::pg_catalog.float8,
    1.20 -                    $2
    1.21 +              ( SELECT @extschema@.ecluster_create_polygon(
    1.22 +                  pg_catalog.array_agg(
    1.23 +                    @extschema@.coords_to_epoint(
    1.24 +                      ("coord" OPERATOR(pg_catalog.->>) 0)::pg_catalog.float8,
    1.25 +                      ("coord" OPERATOR(pg_catalog.->>) 1)::pg_catalog.float8,
    1.26 +                      $2
    1.27 +                    )
    1.28                    )
    1.29 -                ))
    1.30 +                )
    1.31                  FROM @extschema@.GeoJSON_LinearRing_vertices("coord_array", $2)
    1.32                  AS "coord"
    1.33                )
     2.1 --- a/latlon--0.15.sql	Mon Nov 30 17:25:32 2020 +0100
     2.2 +++ b/latlon--0.15.sql	Mon Nov 30 18:50:48 2020 +0100
     2.3 @@ -1729,7 +1729,7 @@
     2.4      WHEN 'MultiLineString' THEN
     2.5        ( SELECT @extschema@.ecluster_concat(pg_catalog.array_agg(
     2.6            ( SELECT @extschema@.ecluster_create_path(pg_catalog.array_agg(
     2.7 -              coords_to_epoint(
     2.8 +              @extschema@.coords_to_epoint(
     2.9                  ("coord" OPERATOR(pg_catalog.->>) 0)::pg_catalog.float8,
    2.10                  ("coord" OPERATOR(pg_catalog.->>) 1)::pg_catalog.float8,
    2.11                  $2
    2.12 @@ -1762,13 +1762,15 @@
    2.13      WHEN 'MultiPolygon' THEN
    2.14        ( SELECT @extschema@.ecluster_concat(pg_catalog.array_agg(
    2.15            ( SELECT @extschema@.ecluster_concat(pg_catalog.array_agg(
    2.16 -              ( SELECT pg_catalog.ecluster_create_polygon(pg_catalog.array_agg(
    2.17 -                  @extschema@.coords_to_epoint(
    2.18 -                    ("coord" OPERATOR(pg_catalog.->>) 0)::pg_catalog.float8,
    2.19 -                    ("coord" OPERATOR(pg_catalog.->>) 1)::pg_catalog.float8,
    2.20 -                    $2
    2.21 +              ( SELECT @extschema@.ecluster_create_polygon(
    2.22 +                  pg_catalog.array_agg(
    2.23 +                    @extschema@.coords_to_epoint(
    2.24 +                      ("coord" OPERATOR(pg_catalog.->>) 0)::pg_catalog.float8,
    2.25 +                      ("coord" OPERATOR(pg_catalog.->>) 1)::pg_catalog.float8,
    2.26 +                      $2
    2.27 +                    )
    2.28                    )
    2.29 -                ))
    2.30 +                )
    2.31                  FROM @extschema@.GeoJSON_LinearRing_vertices("coord_array", $2)
    2.32                  AS "coord"
    2.33                )

Impressum / About Us