Consider the following one-dimensional ARRAY data type and table.
CREATE TYPE phonenumbers AS CHAR(10) ARRAY[20]; CREATE TABLE employee_info (eno INTEGER, phonelist phonenumbers);
The following query returns an updated copy of the phonelist array with every other element updated to the new value:
SELECT ARRAY_UPDATE_STRIDE(phonelist, '9095551234', 1) FROM employee_info;
The following query returns an updated copy of the phonelist array, with a subset of the elements updated to the new value, as specified by the scope reference and stride value. The result is that elements 2 and 4 are updated to the new value. The rest of the elements in the array retain their original values.
SELECT ARRAY_UPDATE_STRIDE(phonelist, '9095551234', 1, 2, 4) FROM employee_info;