ST_SetNoData-PolarDB(PolarDB)-阿里云帮助中心

Sets the NoData value for a specified band of a raster object.

Syntax

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

Parameter	Description
`rast`	The raster object.
`band_sn`	The band number, starting from 0. Set to `-1` to apply the NoData value to all bands.
`nodata_value`	The NoData value to set for the band.

Set the NoData value of band 0 to 999.999:

UPDATE rast SET rast = ST_SetNoData(rast, 0, 999.999);

Output:

(1 row)