From ddc6232a7b14ac910e074acb7725ecad3a470ed9 Mon Sep 17 00:00:00 2001 From: Regina Obe Date: Thu, 17 Feb 2011 13:02:22 +0000 Subject: [PATCH] indent a bit better git-svn-id: http://svn.osgeo.org/postgis/trunk@6841 b70326c6-7e19-0410-871a-916f4a2858ee --- doc/reference_raster.xml | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) diff --git a/doc/reference_raster.xml b/doc/reference_raster.xml index abe5451a0..800ac3824 100644 --- a/doc/reference_raster.xml +++ b/doc/reference_raster.xml @@ -3377,8 +3377,9 @@ WHERE rid = 2; Create a new 1 band raster of pixel-type 2BUI from our original that is reclassified. ALTER TABLE dummy_rast ADD COLUMN map_rast2 raster; -UPDATE dummy_rast SET map_rast2 = ST_MapAlgebra(rast,'CASE WHEN rast - BETWEEN 100 and 250 THEN 1 WHEN rast = 252 THEN 2 WHEN rast BETWEEN 253 and 254 THEN 3 ELSE 0 END', '2BUI') WHERE rid = 2; +UPDATE dummy_rast SET map_rast2 = ST_MapAlgebra(rast,'CASE WHEN rast BETWEEN 100 and 250 THEN 1 +WHEN rast = 252 THEN 2 +WHEN rast BETWEEN 253 and 254 THEN 3 ELSE 0 END', '2BUI') WHERE rid = 2; SELECT DISTINCT ST_Value(rast,1,i,j) As origval, ST_Value(map_rast2, 1, i, j) As mapval FROM dummy_rast CROSS JOIN generate_series(1, 5) AS i CROSS JOIN generate_series(1,5) AS j -- 2.50.1