ST_Geometry Type Ordering | Geospatial Data Types | Teradata Vantage - 17.10 - Ordering - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Geospatial Data Types

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)

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 the CREATE ORDERING statement in Teradata Vantageā„¢ - SQL Data Definition Language Syntax and Examples, B035-1144.