Re: Updating an array

Renaud Tthonnart <thonnart@amwdb.u-strasbg.fr> writes:
> *** 2 ***
> UPDATE xxx
> SET nombres[5]= 63
> WHERE id = 1;
> ==> Here, I'd just append a new element to the array. That doesn't work

This does work --- at least for one-dimensional arrays --- as of 7.1.

            regards, tom lane