Teradata Database automatically generates the following routines for each ARRAY data type you create.
|Constructor function||Allocates an ARRAY type instance and sets all the elements to an uninitialized state if the DEFAULT NULL clause was not specified. If DEFAULT NULL was specified, all elements are set to null.|
|Constructor method||Takes one or more arguments and initializes each element of the array with the corresponding value passed to the method.|
Use the ARRAY constructor expression to create a new instance of an ARRAY data type and initialize it using the autogenerated constructor method or function. For details about the ARRAY constructor expression, see “ARRAY Functions and Operators” in SQL Functions, Operators, Expressions, and Predicates.
Teradata Database automatically generates the following functionality for each ARRAY data type you create.
|ARRAY type transform||from-sql and to-sql functionality associated with the transform of an ARRAY type. The ARRAY values are transformed to/from a VARCHAR(length) value, where length depends on the element type and the total number of elements defined in the ARRAY.
For detailed information about transform input/output strings for ARRAY types, see External Representations for UDTs
|ARRAY type ordering||Basic ordering functionality for an ARRAY type.|
|ARRAY type cast||Casting functionality for an ARRAY type. Two autogenerated casts are provided: VARCHAR to ARRAY, and ARRAY to VARCHAR.|
For detailed information, see “CREATE TYPE (ARRAY Form)” in SQL Data Definition Language.