16.20 - Return Value - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ Geospatial Data Types

Teradata Database
Teradata Vantage NewSQL Engine
Release Number
Release Date
March 2019
Content Type
Programming Reference
Publication ID
English (United States)

Returns an ST_Geometry value.

Returns “GEOMETRYCOLLECTION EMPTY” if there is no intersection between the objects resulting from any step of the aggregation.

NULL values are ignored in the aggregation. If all values in the aggregation are null, the return value is NULL.

Because the order in which the rows are processed and per-AMP results are returned for aggregation can vary from run to run, the ordering of the values in the results can vary between different instances of identical queries. Although the order of the individual values in the returned results can vary, the overall results from the query will be the same when an identical query is run on the same data.