6.2. delete

delete removes an element.

The following statement removes from ARRAY the element specified by the index tuple. The value will no longer be available, and subsequent iterations will not report the element. It is not an error to delete an element that does not exist.

delete ARRAY[INDEX1, INDEX2, ...]

delete ARRAY[INDEX1, INDEX2, ...]

The following syntax removes all elements from ARRAY:

delete ARRAY

delete ARRAY

The following statement removes the value of SCALAR. Integers and strings are cleared to zero and null ("") respectively, while statistics are reset to their initial empty state.

delete SCALAR

delete SCALAR