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.