15.00 - System Default Ordering Functionality for ARRAY and VARRAY Types - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1184-015K
Language
English (United States)

System Default Ordering Functionality for ARRAY and VARRAY Types

Teradata provides only basic ordering functionality for a newly created one‑dimensional or multidimensional ARRAY/VARRAY type. This ordering functionality is provided to avoid hashing issues and to permit ARRAY/VARRAY types to be valid for columns in SET tables. The basic ordering functional that Teradata provides does not permit relational comparison of ARRAY/VARRAY values in any form.