ARRAY_Constructor_Expression - Teradata Vantage NewSQL Engine - 16.20

Teradata Vantageā„¢ Data Types and Literals

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1143-162K

Purpose

Constructs a new instance of an ARRAY type and initializes it using the ARRAY constructor method or function.

Syntax



array_name
The name of the ARRAY data type that you want to initialize.
element_expression

An expression that evaluates to a literal value. The data type of the value must be the same as the element type of the array_name array.

element_expression can be repeated n times, where n is the declared size of the array_name array. The maximum limit for n is 2559.