ST_YMin

更新时间:
复制 MD 格式

Returns the minimum Y coordinate of the bounding box of a geometry, Box2D, or Box3D object.

Syntax

float ST_YMin(box3d aGeomorBox2DorBox3D);

Parameters

ParameterDescription
aGeomorBox2DorBox3DThe Box2D, Box3D, or geometry object.

Usage notes

  • The function signature accepts only Box3D. However, ST_YMin auto-casts Box2D and geometry objects at runtime. String representations of Box2D or geometry objects are not auto-cast and therefore cannot be processed.

  • ST_YMin supports 3D objects and preserves Z coordinates.

  • ST_YMin supports circular strings and curves.

Examples

Get the minimum Y coordinate of a LineString:

SELECT ST_YMin('LINESTRING(0 1,2 3)'::geometry);
 st_ymin
---------
       1
(1 row)