Description
The ST_X function returns the X ordinate of the geometry if the geometry
is a point, or Null if the geometry is not a point or is null.
Syntax
ST_X(WritableGeometry geometry)Parameters
| Parameter | Type | Description |
|---|---|---|
| geometry | WritableGeometry | The input geometry. |
Return Values
| Return Type | Description |
|---|---|
| Double | The X 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_X(ST_Point(x, y, 'epsg:4326')) FROM src;