By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Help with an interesting Postgres question: Why isn't an Index Only Scan used on a partition accessed via the parent table?.
with t as (select '{"values": ["11", "22", "33"]}'::jsonb column_name)
select jsonb_set(column_name, '{values}', ((column_name -> 'values') - '33'))
from t
| jsonb_set |
|---|
| {"values": ["11", "22"]} |
with mytable as (select '{"values": [11, 22, 33]}'::jsonb column_name)
select jsonb_set(column_name, '{values}', new_values) new_column_name
from mytable t
left join lateral (
select jsonb_agg(val) new_values
from jsonb_array_elements(t.column_name -> 'values') x(val)
where val::int <> 33
) x on 1 = 1
| new_column_name |
|---|
| {"values": [11, 22]} |