add filter in json array postgresql

Clear Cow answered on November 11, 2022 Popularity 6/10 Helpfulness 4/10

answer add filter in json array postgresql

Comment

SELECT t.id, array_to_json(array_agg(j))
FROM your_table t, json_array_elements(t.jsonColumn) j
WHERE j->>'field' = 'abc'
GROUP BY id;

Popularity 6/10 Helpfulness 4/10 Language sql

Tags: add-filter json postgresql sql

Link to this answer
Share Copy Link

Contributed on Nov 11 2022

Clear Cow

0 Answers Avg Quality 2/10

Oops, You will need to install Grepper and log-in to perform this action.