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.