ST_X

ST_X
Prev	3. Geometry Accessors	Next

Name

ST_X — Returns the x coordinate of a point

double ST_X(bytea Geometry);

Returns the x coordinate of a point. Input geometry must be a point, otherwise throws an error.

2D	3D	M

OGC SFS for SQL. 1.1 (1999)	OGC SFS for SQL. 1.1.0 (2005)	OGC SFS for SQL. 1.2.0 (2006))	SQL-MM Part 3
2.1.3.1	7.2.11.1	7.2.9.2	6.1.3

SELECT ST_X(ST_GeomFromEWKT('POINT(2.5 0 0 -8)'));
--Result
2.5

SELECT ST_X(ST_GeomFromText('POINT(4 0)'));
--Result
4.0

Prev	Up	Next
ST_Summary	Home	ST_Y