[postgis-devel] [PostGIS] #903: [raster] ST_Reclass

PostGIS trac at osgeo.org
Fri Apr 8 12:06:48 PDT 2011

#903: [raster] ST_Reclass
 Reporter:  dustymugs       |       Owner:  dustymugs            
     Type:  task            |      Status:  new                  
 Priority:  medium          |   Milestone:  PostGIS Raster Future
Component:  postgis raster  |     Version:  trunk                
 Keywords:                  |  

Comment(by pracine):

 1) Could it not be VARIADIC of a composite type? e.g.:

 CREATE TYPE reclassarg AS (
     nband int,
     reclassexpr text,
     pixeltype text

 CREATE FUNCTION  ST_Reclass(rast, raster, VARIADIC args reclassarg[])...

 I don't know if this works. I think this comes to the same as your last
 ARRAY solution but I'm not sure.

 I don't think we mind too much about not supporting PostgreSQL 8.3 and

 2) I was planning "rangemin <= x < rangemax". To solve the rangemax issue
 when x = rangemax you could introduce the keyword "rangemax" saying "if
 you use the "rangemax" keyword for rangemax, '<=' is used instead of '<'"
 in the comparison. To be convenient and symetrical you could also support
 the "rangemin" keyword even if we don't really need it.

 Don't forget that we might want to recall a range of values to NULL

Ticket URL: <http://trac.osgeo.org/postgis/ticket/903#comment:3>
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.

More information about the postgis-devel mailing list