Hello Gurus,
Table A has integer[] column. I need to delete specific integer value from
that column.
f1 | f2
1 {100, 101, 102, 103}
2 {200, 300, 400}
I want to remove 101 from f2 and also preserve the order.
f1 | f2
1 {100, 102, 103}
2 {200, 300, 400}
I tried the following query and it did remove the 101 but it didn't
preserve the order.
update tableA set f2 = (select array_agg(X.id) from (select unnest(f2) id
except select 101 id) X) where f1 = 1;
What's the best way to do this?
Thank you,
Choon Park