PolarDB:ST_XMin

Syntax

float8 ST_XMin(raster raster_obj)

Parameters

Usage notes

• If the raster object is georeferenced, the function returns its minimum X-coordinate (the left boundary of the bounding box).

• If the raster object is not georeferenced, the function returns 0.

Examples

select ST_XMin(rast)
from raster_table;

Expected output:

 st_xmin
----------
      120

What's next

• ST_YMin: Returns the minimum Y-coordinate of a raster object.

• ST_XMax: Returns the maximum X-coordinate of a raster object.

• ST_YMax: Returns the maximum Y-coordinate of a raster object.