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?.
create table if not exists testing (val jsonb);
insert into testing values('{"a":"b"}'::jsonb);
insert into testing values('{"a":"b", "errors":["a", "b"]}'::jsonb);
CREATE TABLE
INSERT 0 1
INSERT 0 1
update testing set val = jsonb_set(val, '{errors}'::text[], coalesce(val->'errors', '[]'::jsonb) || '["a","b"]'::jsonb) where val->>'a'='b'
UPDATE 2
select * from testing
| val |
|---|
| {"a": "b", "errors": ["a", "b"]} |
| {"a": "b", "errors": ["a", "b", "a", "b"]} |
SELECT 2