I have a raster column with "NoData" value of 3.40282346638529e+038 in PostGIS. I want to change the NoData value to 100. I used the following code:
SELECT ST_Reclass(ukc,1,'3.40282346638529e+038:100', '32BF', 3.40282346638529e+038) rast
INTO for_delete1
FROM raster_table
but it changed all pixel values to 3.40282346638529e+038 and it changed non of the NoData pixels!! then, I used the same query and just changed '3.40282346638529e+038:100' to '100:3.40282346638529e+038'. This one also made some strange changes but the NoData value is still the same.
How can I change the NoData value for a raster column in PostGIS?