Re: Updating Arrays

Merlin Moncure <mmoncure(at)gmail(dot)com> writes:
> On Mon, Aug 22, 2011 at 8:49 PM, Bob Pawley <rjpawley(at)shaw(dot)ca> wrote:
>> I'm not sure what you mean.
>> _base -- not base -- is the column name.

> oops. anyways, the important point is on the right side of the equals sign.
> Update library.compare set _base[2] = 2 where process_id = 2;

Right. If you assign to _base[2], you must provide a single numeric
value. Not a one-element array.

OTOH, if you were to assign to _base[2:2] (an array slice containing
just that one element), you must provide a one-element numeric array on
the righthand side. So if there's some reason why you need to write
'{2}' and not just '2', you can accommodate that by adjusting what
you're assigning to.

regards, tom lane