How to change value in JSONB?

Question

Java

I have a table that has a data field that is in JSONB format. This field has the following structure:
{"requisites":
{"kpp": "212997417444",
"ogrn":
{"number": "219322571340"}}
I need to change the value for the kpp field. I'm trying to do it like this:
update 'table name' set data = jsonb_set(data, '{requisites}', '{"kpp": 777}') where 'something';
But at the same time, everything else (for example, ogrn) is simply erased, and I need to save it and change only kpp. Tell me, please, what am I doing wrong? Thanks in advance!

Answer 1

set data = jsonb_set(data, '{requisites,kpp}', '777')

Answer 2

You must specify the full path.

select jsonb_value,
       jsonb_set(jsonb_value, '{requisites,kpp}', '"777"', false)
FROM test;

https://dbfiddle.uk/?rdbms=postgres_12&fiddle=3cfb...
PS. In general, changing a string attribute to a numeric one is not safe. In the application, this may come back to haunt - it is not in the know ...