Consider the following 1-D ARRAY data type:
CREATE TYPE phonenumbers_ary AS CHAR(10) ARRAY;
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 = '5551234567';