5. Geospatial Functions
:
X
Share this page
X
X(p POINT)
Alias: ST_X
Returns the X-coordinate of
p
.
Result type: float
Example:
SELECT X(POINTFROMTEXT('POINT(5 10)'));
-------------
col1
-------------
5.000
-------------