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

Teradata Database SQL Data Definition Language Detailed Topics

prodname
Teradata Database
vrm_release
15.00
category
Programming Reference
featnum
B035-1184-015K

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.