Thank you,
Choon Park
On Wed, Feb 20, 2013 at 12:06 PM, Russell Keane <Russell.Keane@xxxxxxxxxx> wrote:
>>Sorry,
>>
>>It's not ordered by value. It's not sorted list unfortunately. It can be '{100, 120, 102, 130, 104}'.
>>
>>Do you have other suggestion?
>>
>>Thank you,
>>Choon Park
>
>This should work:
>update a set f2 = (select array_agg(X.id) from (select f1, unnest(f2) id from a where f1 = 1 except select 1 f1, 101 id) X) where f1 = 1;
And with the correct table name:
update tableA set f2 = (select array_agg(X.id) from (select f1, unnest(f2) id from tableA where f1 = 1 except select 1 f1, 101 id) X) where f1 = 1;
