ST_Z

ST_Z
Prev	3. Geometry Accessors	Next

Name

ST_Z — Returns the z coordinate of a point

double ST_Z(bytea Geometry);

Returns the Z coordinate of a point. If the Z coordinate is not available, returns Null. 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
-	-	7.2.9.2	6.1.5

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

Prev	Up	Next
ST_Y	Home	ST_ZmFlag