This function sets the NoData value for a specified band of a raster object.


raster ST_SetNoData(raster rast, integer band_sn, double nodata_value);


Parameter Description
rast The raster object.
band The sequence number of the band, which starts from 0. A value of -1 indicates all bands.
nodata_value The NoData value of the band.


update rast set rast=ST_SetNoData(rast,0, 999.999);

(1 row)