Definition
The ST_Raster.deleteColormap function removes the raster color map from an ST_Raster object. If the ST_Raster object does not have a color map, the function returns an error.
Syntax
Oracle
deleteColormap () RETURN ST_RASTER;
PostgreSQL
deleteColormap (raster IN ST_RASTER) RETURN ST_RASTER;
SQL Server
deleteColormap () RETURN ST_RASTER;
Returns
ST_Raster
Parameters
None
Examples
In this example, the color map of an ST_Raster object that corresponds to the table row that has a raster_id column value of 50 is deleted.
Oracle
UPDATE NOVA n
SET image = n.image.deleteColormap()
WHERE n.image.raster_id = 50;
PostgreSQL
UPDATE nova
SET image = deleteColormap(image)
WHERE raster_id(image) = 50;
SQL Server
UPDATE nova
SET image = deleteColormap()
WHERE image.raster_id = 50;