[postgis-devel] [PostGIS] #644: ST_MapAlgebra raster/scripts/plpgsql some broken

[PostGIS]

#644: ST_MapAlgebra raster/scripts/plpgsql some broken
----------------------------+-----------------------------------------------
 Reporter:  robe            |       Owner:  pracine      
     Type:  defect          |      Status:  new          
 Priority:  medium          |   Milestone:  PostGIS 2.0.0
Component:  postgis raster  |     Version:  trunk        
 Keywords:                  |  
----------------------------+-----------------------------------------------
 -- this is invalid (that should be $4 I believe)

 {{{

 CREATE OR REPLACE FUNCTION ST_MapAlgebra(rast raster, band integer,
 expression text, nodatavalexpr text)
     RETURNS raster
     AS 'SELECT ST_MapAlgebra($1, $2, $3, nodatavalexpr, NULL)'
     LANGUAGE 'SQL' IMMUTABLE;
 }}}


 --- this is invalid (it might be because I'm testing on 9.1 (though 9.0
 should have the same issue) since both support named variables function
 call syntax and so are more stringent about naming -

 {{{
 CREATE OR REPLACE FUNCTION ST_MapAlgebra(rast raster, expression text,
 nodatavalexpr text)
     RETURNS raster
     AS 'SELECT ST_MapAlgebra($1, 1, $2, $3, NULL)'
     LANGUAGE 'SQL' IMMUTABLE;
 }}}

 gives error

 ERROR:  cannot change name of input parameter "pixeltype"
 HINT:  Use DROP FUNCTION first.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/644>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.