15.10 - ST_Z - Teradata Database

Teradata Database SQL Geospatial Types

prodname
Teradata Database
vrm_release
15.10
category
Programming Reference
featnum
B035-1181-151K

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;