[raster]: ST_Reclass Working with negative numbers seems broken
|Reported by:||robe||Owned by:||Bborie Park|
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?
what the heck does that mean?
at any rate if this is not a bug, it should be documented as its not intuitively obvious.