Supported ARRAY and VARRAY Data Type Elements
The element types of an ARRAY or VARRAY UDT must be chosen from any of the Teradata data type categories contained in the following list.
All supported predefined data types with the exception of the following types.
- BLOB
- CLOB
- LOB-based UDT
- Geospatial
- One-dimensional ARRAY types
- Multidimensional ARRAY types
Transform Input/Output Strings for ARRAY/VARRAY Types
See ARRAY/VARRAY Data Type Rules and Guidelines for information about the transform input/output strings for ARRAY and VARRAY types.
ARRAY and VARRAY Columns in SELECT Requests
You cannot specify an ARRAY or VARRAY column in the ORDER BY, GROUP BY, or HAVING clauses of a SELECT request.
ARRAY and VARRAY Columns in an Index Definition
You cannot specify an ARRAY or VARRAY column in a primary, secondary, or join index.