Re: Alter table with arrays

igor <igor_kh(at)mailru(dot)com> writes:
> Help me please to alter table with arrays .
> And now I would like to increase the number of colomns of array from
> two to tree. What is the way to fulfill these operation?

As of 7.0.*, the only way to change the size of an array is to replace
the whole array, ie,
UPDATE table SET arraycol = '{ .... }'

I have recently fixed the array code so that you can enlarge an array
by assigning to an element or slice. For example, given an array with
current dimensions [1:3] you can assign to array[4] (or array[0], or
array[2:7], etc). Restriction: you can't leave "holes" in the array,
so it only works for 1-D arrays. This will appear in 7.1.

regards, tom lane