ST_Y

ST_Y
Prev	3. Geometry Accessors	Next

Name

ST_Y — Returns the y coordinate of a point

double ST_Y(bytea Geometry);

Returns the y 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.4

SELECT ST_Y(ST_GeomFromEWKT('POINT(2 5 0 -8)'));
--Result
5

SELECT ST_Y(ST_GeomFromText('POINT(4 8)'));
--Result
8