Get and set the z coordinate of an ST_Point value.
Valid Data Types
ST_Point
Result Type
IF you pass in … | THEN ST_Z returns … |
---|---|
no argument | a FLOAT value for the z coordinate. |
the zcoord argument | an ST_Geometry value where the z coordinate is set to zcoord. |
NULL | NULL |
If the input geometry is a non-point, the system returns an error.
If the input geometry is a 2D point, and no zcoord argument is passed, the system returns an error.