>>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; Regards, Russell Keane INPS Tel: +44 (0)20 7501 7277 [cid:[email protected]] Follow us<https://twitter.com/INPSnews> on twitter | visit www.inps.co.uk<http://www.inps.co.uk/>
<<inline: image001.jpg>>
