ST_Geometry Type Ordering | Geospatial Data Types | Teradata Vantage - 17.05 - Ordering - Teradata Database

Teradata Vantageā„¢ - Geospatial Data Types

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
17.05
created_date
June 2020
category
Programming Reference
featnum
B035-1181-170K

Because the database requires ordering functionality for UDTs, an ordering definition exists for the ST_Geometry type. In general, however, ordering ST_Geometry types by their ordering definitions is not useful or meaningful.

To determine spatial relationships between geometries, for example whether one ST_Geometry type is equal to another, the best practice is to use the ST_Geometry spatial methods, for example geom1.ST_Equals(geom2).

For more information on ordering functionality, see "CREATE ORDERING" in Teradata Vantageā„¢ - SQL Data Definition Language Syntax and Examples, B035-1144.