Description
The ST_Y function returns the Y ordinate of the geometry if the geometry
is a point, or Null if the geometry is not a point or is null.
Syntax
ST_Y(WritableGeometry geometry)Parameters
| Parameter | Type | Description |
|---|---|---|
| geometry | WritableGeometry | The input geometry. |
Return Values
| Return Type | Description |
|---|---|
| Double | The Y ordinate of the geometry if the geometry is a point, or Null if the geometry is not a point or is null. |
Examples
SELECT ST_Y(ST_Point(x, y, 'epsg:4326')) FROM src;