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