ARRAY_AGG Function | Data Types and Literals | Teradata Vantage - 17.10 - ARRAY_AGG - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Data Types and Literals

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

An aggregate function for use with ARRAY data types that allows arrays to be created as part of the SELECT list of a query.

The data type information from the array_expression which resolves to an ARRAY data type is used to set the return type of ARRAY_AGG.

ANSI Compliance

This statement is ANSI SQL:2011 compliant, but includes non-ANSI Teradata extensions.