Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
Returns the x coordinate of the ST_Geometry value.
ST_X(geo1)
geo1
ST_Geometry
The ST_Geometry value from which to determine the x coordinate.
DOUBLE Returns the x coordinate of the ST_Geometry value.
The following statement returns the result 10.0:
10.0
SELECT ST_X(ST_Point(10.0,20.0,4326))
Syntax