ST_Z Method | Geospatial Data Types | Teradata Vantage - 17.10 - ST_Z - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Geospatial Data Types

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1181-171K
Language
English (United States)

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.