ST_Raster.deleteColormap

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
SET image = image.deleteColormap()
WHERE 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;

3/6/2012