Example: Creating Tables and Set Elements in a 1-D Array

Teradata Database SQL Functions, Operators, Expressions, and Predicates

brand
Software
prodname
Teradata Database
vrm_release
16.10
category
Programming Reference
featnum
B035-1145-161K

Consider the following 1-D ARRAY data type:

   CREATE TYPE phonenumbers_ary AS CHAR(10) ARRAY[5];

The following statement creates a table with a column named ephone with a data type of phonenumbers_ary.

   CREATE TABLE my_table (eno INTEGER, ephone phonenumbers_ary);

The following statement uses an ARRAY element reference to set element 3 of the array to the value '5551234567'. If elements 1 and 2 in the array were not initialized, this UPDATE statement automatically sets those elements to null.

   UPDATE my_table
   SET ephone[3] = '5551234567';