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