Example: Showing the ARRAY Element Reference Syntax - 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

If a table contains a column named ephone, and the data type of the ephone column is a 1-D ARRAY, then the following shows the ARRAY element reference syntax to access the value of the 5th element of the array:

ephone[5]