From 8faec69f9ae3da29bf29ad1e1872b98f11a38694 Mon Sep 17 00:00:00 2001 From: Bborie Park Date: Thu, 17 Nov 2011 22:48:57 +0000 Subject: [PATCH] Fix the 8.4 error only described in #1296. git-svn-id: http://svn.osgeo.org/postgis/trunk@8165 b70326c6-7e19-0410-871a-916f4a2858ee --- raster/test/regress/rt_mapalgebrafctngb.sql | 10 ++++++---- 1 file changed, 6 insertions(+), 4 deletions(-) diff --git a/raster/test/regress/rt_mapalgebrafctngb.sql b/raster/test/regress/rt_mapalgebrafctngb.sql index 75b620f30..97e30f576 100644 --- a/raster/test/regress/rt_mapalgebrafctngb.sql +++ b/raster/test/regress/rt_mapalgebrafctngb.sql @@ -5,23 +5,25 @@ CREATE OR REPLACE FUNCTION ST_Sum(matrix float[][], nodatamode text, variadic ar RETURNS float AS $$ DECLARE + _matrix float[][]; x1 integer; x2 integer; y1 integer; y2 integer; sum float; BEGIN + _matrix := matrix; sum := 0; FOR x in array_lower(matrix, 1)..array_upper(matrix, 1) LOOP FOR y in array_lower(matrix, 2)..array_upper(matrix, 2) LOOP - IF matrix[x][y] IS NULL THEN + IF _matrix[x][y] IS NULL THEN IF nodatamode = 'ignore' THEN - matrix[x][y] := 0; + _matrix[x][y] := 0; ELSE - matrix[x][y] := nodatamode::float; + _matrix[x][y] := nodatamode::float; END IF; END IF; - sum := sum + matrix[x][y]; + sum := sum + _matrix[x][y]; END LOOP; END LOOP; RETURN sum; -- 2.40.0