[postgis-tickets] [PostGIS] #2555: [raster]: ST_Reclass Working with negative numbers seems broken

PostGIS trac at osgeo.org
Sat Nov 30 18:29:53 PST 2013


#2555: [raster]: ST_Reclass Working with negative numbers seems broken
--------------------+-------------------------------------------------------
 Reporter:  robe    |       Owner:  dustymugs    
     Type:  defect  |      Status:  new          
 Priority:  medium  |   Milestone:  PostGIS 2.0.5
Component:  raster  |     Version:  2.1.x        
 Keywords:          |  
--------------------+-------------------------------------------------------
 I'm not sure if this is just my misunderstanding of how reclass works or
 if I'm missing something.  I have a temp raster in celsius*10 units and
 wanted to get down to celsius by doing this:


 {{{
 UPDATE t SET rast = ST_Reclass(rast,1,'-9000-9000:-900-900'::text,
 '32BF'::text);
 }}}

 Results all come out NULL, but

 {{{
 UPDATE t SET rast = ST_Reclass(rast,1,'0-9000:0-900'::text, '32BF'::text);
 }}}

 seems to work as expected

 Am I missing something.  If so not clear from the docs how someone can
 reclassify negative numbers.  There are some examples in the regress tests
 though none of those seem to amp a negative to a negative number and one
 even uses the letter a?


 {{{
 'a-100]:50-1,(-100-1000]:150-50,(1000-10000]:254-150'
 }}}


 what the heck does that mean?

 at any rate if this is not a bug, it should be documented as its not
 intuitively obvious.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2555>
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-tickets mailing list