Get and set the z coordinate of an ST_Point value.
|
Argument … |
Specifies … |
|
zcoord |
a FLOAT value for the new z coordinate of the ST_Point value. |
|
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, Teradata Database returns an error.
If the input geometry is a 2D point, and no zcoord argument is passed, Teradata Database returns an error.
ST_Point
This method can be used to convert a 2D point to a 3D point if a zcoord argument is passed.
UPDATE sample_shapes
SET shape=shape.ST_Z(35.2)
WHERE skey = 1;