From 8a2cfd063bff5d65f8fc694e1553a7bd821db73a Mon Sep 17 00:00:00 2001 From: Sandro Santilli Date: Sat, 28 Jan 2012 23:11:08 +0000 Subject: [PATCH] Fix _ST_AddFaceSplit code against PostgreSQL 9.1 git-svn-id: http://svn.osgeo.org/postgis/trunk@8961 b70326c6-7e19-0410-871a-916f4a2858ee --- topology/sql/sqlmm.sql.in.c | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/topology/sql/sqlmm.sql.in.c b/topology/sql/sqlmm.sql.in.c index a6ceec1ee..6ab4ee3e7 100644 --- a/topology/sql/sqlmm.sql.in.c +++ b/topology/sql/sqlmm.sql.in.c @@ -2727,10 +2727,10 @@ BEGIN RAISE DEBUG 'Edge % splitted face %', anedge, oface; #endif - sql := 'WITH ids as ( select edge from unnest(' + sql := 'WITH ids as ( select row_number() over () as seq, edge from unnest(' || quote_literal(fan.newring_edges::text) || '::int[] ) u(edge) ), edges AS ( select CASE WHEN i.edge < 0 THEN ST_Reverse(e.geom) ELSE e.geom END as g FROM ids i left join ' - || quote_ident(atopology) || '.edge_data e ON(e.edge_id = abs(i.edge)) ) SELECT ST_MakePolygon(ST_MakeLine(g.g)) FROM edges g;'; + || quote_ident(atopology) || '.edge_data e ON(e.edge_id = abs(i.edge)) ORDER BY seq) SELECT ST_MakePolygon(ST_MakeLine(g.g)) FROM edges g;'; #ifdef POSTGIS_TOPOLOGY_DEBUG RAISE DEBUG '%', sql; #endif -- 2.40.0