Re: [GENERAL] How to remove an item from integer array type

[Russell Keane]

>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.jpg@01CE0F8B.75C5EF60]
Follow us<https://twitter.com/INPSnews> on twitter | visit 
www.inps.co.uk<http://www.inps.co.uk/>

<<inline: image001.jpg>>