[TD_SYSFNLIB.] UNNEST ( [ key_expr, ] array_expr ) [ WITH ORDINALITY ]
Syntax Elements
- 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