16.20 - System Default Ordering Functionality for ARRAY and VARRAY Types - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Detailed Topics

Teradata Database
Teradata Vantage NewSQL Engine
Release Number
March 2019
Content Type
Programming Reference
Publication ID
English (United States)

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.