ST_3DDistance Method | Geospatial Data Types | Teradata Vantage - 17.10 - ST_3DDistance Method - 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)

Returns the distance between two ST_Geometry values. ST_3DDistance considers z coordinate values, if they exist in the geometries passed to it.

Valid Data Types

  • ST_Point
  • ST_MultiPoint
  • ST_LineString
  • ST_MultiLineString

To be valid with ST_3DDistance, these shapes must include z coordinates.

Result Type

Returns a FLOAT value. The distance units are those of the two input geometries.

Returns 0 if the two geometries intersect.

Returns NULL if the ageometry argument is NULL.