>>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
Follow us on twitter | visit www.inps.co.uk |
