AggGeom Operator Syntax | Teradata Vantage - 17.10 - AggGeom Syntax - 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)
[TD_SYSFNLIB.] AggGeom (
  ON ( SELECT ageometry [, part_column_list ] FROM [ database_name. ] table_name )
  [ PARTITION BY part_column_list ]
  [ USING OPERATION ('value') ]
) [AS] correlation_name [ ( column_list ) ]

Syntax Elements

ageometry
A constant or column expression for which the aggregation is to be computed. The data type of ageometry is ST_Geometry.
part_column_list
The column name set by which rows are to be partitioned before being passed to the operator. If a PARTITION BY clause is used, the list of columns must match the part_column_list that was passed to the table operator.
database_name
table_name
The table that contains the geometry type column for which the aggregation is to be computed.
value
The type of aggregation operation desired, either Union or Intersection. Union is the default. The value must be delimited by apostrophe (single-quote) characters.
correlation_name
A name to be assigned to the table returned by the table operator.
column_list
Optional list of custom names for the columns returned by the table operator. These names override the column names that would be otherwise generated by the operator. If you specify any column names, you must provide names for all columns returned. If more than one column is returned by the operator, separate the names with commas.