ST_EraseOverview-ApsaraDB RDS(RDS)-阿里云帮助中心

Clears the specified area of a raster object by filling it with a NoData value or zero.

Syntax

raster ST_EraseOverview(raster raster_obj, Box extent, BoxType type, boolean useNodata);

Parameter	Description
`raster_obj`	The raster object.
`extent`	The area to clear, in the format `'((minX,minY),(maxX,maxY))'`.
`type`	The coordinate system of the area. Valid values: `Raster` (pixel coordinates), `World` (world coordinates).
`useNodata`	Specifies whether to fill the cleared area with the predefined NoData value. If set to `false`, or if no NoData value is defined, the area is filled with `0`.

SELECT ST_EraseOverview(raster_obj, '((0,0),(100,100))', 'Raster', false)
FROM raster_table
WHERE id = 100;