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

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1184-162K
Language
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.