From 7cd75c1450be26fd72a17d72276c800c1c67e910 Mon Sep 17 00:00:00 2001 From: Bborie Park Date: Fri, 27 May 2011 14:42:23 +0000 Subject: [PATCH] Added default values for function arguments of ST_Reclass git-svn-id: http://svn.osgeo.org/postgis/trunk@7276 b70326c6-7e19-0410-871a-916f4a2858ee --- raster/rt_pg/rtpostgis.sql.in.c | 10 +++------- 1 file changed, 3 insertions(+), 7 deletions(-) diff --git a/raster/rt_pg/rtpostgis.sql.in.c b/raster/rt_pg/rtpostgis.sql.in.c index 2f2dc4e85..8fff7b461 100644 --- a/raster/rt_pg/rtpostgis.sql.in.c +++ b/raster/rt_pg/rtpostgis.sql.in.c @@ -1151,15 +1151,11 @@ CREATE OR REPLACE FUNCTION st_reclass(rast raster, VARIADIC reclassargset reclas END; $$ LANGUAGE 'plpgsql' IMMUTABLE STRICT; -CREATE OR REPLACE FUNCTION st_reclass(rast raster, nband int, reclassexpr text, pixeltype text, nodataval double precision) +-- Cannot be strict as "nodataval" can be NULL +CREATE OR REPLACE FUNCTION st_reclass(rast raster, nband int, reclassexpr text, pixeltype text, nodataval double precision DEFAULT NULL) RETURNS raster AS $$ SELECT st_reclass($1, ROW($2, $3, $4, $5)) $$ - LANGUAGE 'SQL' IMMUTABLE STRICT; - -CREATE OR REPLACE FUNCTION st_reclass(rast raster, nband int, reclassexpr text, pixeltype text) - RETURNS raster - AS $$ SELECT st_reclass($1, ROW($2, $3, $4, NULL)) $$ - LANGUAGE 'SQL' IMMUTABLE STRICT; + LANGUAGE 'SQL' IMMUTABLE; CREATE OR REPLACE FUNCTION st_reclass(rast raster, reclassexpr text, pixeltype text) RETURNS raster -- 2.50.1