UNNEST - Teradata Vantage NewSQL Engine - 16.20

Teradata Vantageā„¢ Data Types and Literals

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1143-162K

Purpose

A table function for use with ARRAY data types that allows arrays to be converted into column tables.

Syntax



TD_SYSFNLIB.
Name of the database where the function is located.
key_expr
An expression that evaluates to a Teradata data type, except for ARRAY, UDT, Period data type, BLOB, or CLOB.
array_expr
An ARRAY expression, which is one of the following:
  • A reference to an ARRAY column
  • An ARRAY constructor expression
  • A UDF expression
  • A UDM expression