Removing JSONB key across all elements of nested array
От | JP |
---|---|
Тема | Removing JSONB key across all elements of nested array |
Дата | |
Msg-id | E1755008-044A-4C24-A18C-AAF04B52ED28@puris.lv обсуждение исходный текст |
Ответы |
Re: Removing JSONB key across all elements of nested array
|
Список | pgsql-sql |
Hi, I'm trying to remove JSONB key from following sample JSON { "spec": { "id": "485197a6-253a-42b3-9c07-6bac07c02166", "buildings": [ { "id": "1b6754b5-c1db-4fdd-af39-32ac173c88cb", "equipment": { "selected_inverters": { "15c9e4a2-5dc7-4017-a09f-1d8e75bdfaef": { "count": 1 } } } }, { "id": "0c6d0627-9fd9-4989-819c-35743640052d", "equipment": { "selected_inverters": { "125a2eb4-f26f-4d07-89fa-f14df9dac7cf": { "count": 2 } } } } ] } } I've succeeded to do so with following query SELECT my_jsonb #- '{spec,buildings,0,equipment,selected_inverters}') #- '{spec,buildings,1,equipment,selected_inverters}' ASmy_jsob FROM my_table This feels like a nasty solution, more so.. I may have various number of dicts in the buildings array. Does anyone have some ideas on how I could implement something like the following? SELECT my_jsonb #- '{spec,buildings,*,equipment,selected_inverters}') AS my_jsob FROM my_table
В списке pgsql-sql по дате отправления: