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 )