# HG changeset patch # User jbe # Date 1606758648 -3600 # Node ID 1cdb3da501761d317bdb6eaf65828de1a042c921 # Parent 76b3fd3293fc04afa9423edd297aa54f2421459b Bugfix regarding schema installation in GeoJSON_to_ecluster function diff -r 76b3fd3293fc -r 1cdb3da50176 latlon--0.14--0.15.sql --- a/latlon--0.14--0.15.sql Mon Nov 30 17:25:32 2020 +0100 +++ b/latlon--0.14--0.15.sql Mon Nov 30 18:50:48 2020 +0100 @@ -921,7 +921,7 @@ WHEN 'MultiLineString' THEN ( SELECT @extschema@.ecluster_concat(pg_catalog.array_agg( ( SELECT @extschema@.ecluster_create_path(pg_catalog.array_agg( - coords_to_epoint( + @extschema@.coords_to_epoint( ("coord" OPERATOR(pg_catalog.->>) 0)::pg_catalog.float8, ("coord" OPERATOR(pg_catalog.->>) 1)::pg_catalog.float8, $2 @@ -954,13 +954,15 @@ WHEN 'MultiPolygon' THEN ( SELECT @extschema@.ecluster_concat(pg_catalog.array_agg( ( SELECT @extschema@.ecluster_concat(pg_catalog.array_agg( - ( SELECT pg_catalog.ecluster_create_polygon(pg_catalog.array_agg( - @extschema@.coords_to_epoint( - ("coord" OPERATOR(pg_catalog.->>) 0)::pg_catalog.float8, - ("coord" OPERATOR(pg_catalog.->>) 1)::pg_catalog.float8, - $2 + ( SELECT @extschema@.ecluster_create_polygon( + pg_catalog.array_agg( + @extschema@.coords_to_epoint( + ("coord" OPERATOR(pg_catalog.->>) 0)::pg_catalog.float8, + ("coord" OPERATOR(pg_catalog.->>) 1)::pg_catalog.float8, + $2 + ) ) - )) + ) FROM @extschema@.GeoJSON_LinearRing_vertices("coord_array", $2) AS "coord" ) diff -r 76b3fd3293fc -r 1cdb3da50176 latlon--0.15.sql --- a/latlon--0.15.sql Mon Nov 30 17:25:32 2020 +0100 +++ b/latlon--0.15.sql Mon Nov 30 18:50:48 2020 +0100 @@ -1729,7 +1729,7 @@ WHEN 'MultiLineString' THEN ( SELECT @extschema@.ecluster_concat(pg_catalog.array_agg( ( SELECT @extschema@.ecluster_create_path(pg_catalog.array_agg( - coords_to_epoint( + @extschema@.coords_to_epoint( ("coord" OPERATOR(pg_catalog.->>) 0)::pg_catalog.float8, ("coord" OPERATOR(pg_catalog.->>) 1)::pg_catalog.float8, $2 @@ -1762,13 +1762,15 @@ WHEN 'MultiPolygon' THEN ( SELECT @extschema@.ecluster_concat(pg_catalog.array_agg( ( SELECT @extschema@.ecluster_concat(pg_catalog.array_agg( - ( SELECT pg_catalog.ecluster_create_polygon(pg_catalog.array_agg( - @extschema@.coords_to_epoint( - ("coord" OPERATOR(pg_catalog.->>) 0)::pg_catalog.float8, - ("coord" OPERATOR(pg_catalog.->>) 1)::pg_catalog.float8, - $2 + ( SELECT @extschema@.ecluster_create_polygon( + pg_catalog.array_agg( + @extschema@.coords_to_epoint( + ("coord" OPERATOR(pg_catalog.->>) 0)::pg_catalog.float8, + ("coord" OPERATOR(pg_catalog.->>) 1)::pg_catalog.float8, + $2 + ) ) - )) + ) FROM @extschema@.GeoJSON_LinearRing_vertices("coord_array", $2) AS "coord" )