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 test (jsonb_value jsonb);
insert into test values
('{"requisites":{"kpp": "212997417444","ogrn":{"number": "219322571340"}}}');
CREATE TABLE
INSERT 0 1
select jsonb_value,
jsonb_set(jsonb_value, '{requisites,kpp}', '"777"', false)
FROM test;
| jsonb_value | jsonb_set |
|---|---|
| {"requisites": {"kpp": "212997417444", "ogrn": {"number": "219322571340"}}} | {"requisites": {"kpp": "777", "ogrn": {"number": "219322571340"}}} |
SELECT 1