Re: Updating an array - Mailing list pgsql-general

From Tom Lane
Subject Re: Updating an array
Date
Msg-id 28569.982949220@sss.pgh.pa.us
Whole thread Raw
In response to Updating an array  (Renaud Tthonnart <thonnart@amwdb.u-strasbg.fr>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Alex Pilosov
Date:
Subject: Re: drop a constraint
Next
From: Soma Interesting
Date:
Subject: Re: International support