This function clears the specified area of a raster object.
Syntax
raster ST_EraseOverview(raster raster_obj, Box extent, BoxType type, boolean useNodata);
Parameters
Parameter | Description |
---|---|
raster_obj | The raster object. |
extent | The area to be cleared, in the format of '((minX,minY),(maxX,maxY))' .
|
type | The coordinate type of the area to be cleared. The value must be Raster or World, where Raster indicates pixel coordinates and World indicates world coordinates. |
useNodata | Indicates whether to use the predefined NoData value to fill the area to be cleared. If this parameter is set to false or the NoData value is not defined, 0 is used to fill the area. |
Examples
Select ST_EraseOverview(raster_obj, '((0,0),(100,100))', 'Raster', false) from raster_table where id=100;