This query
SELECT '{"a": 1, "b": [{"x": "y"}]}'::jsonb || '{"b": [{"a": "b"}]}'::jsonb
returns
"{"a": 1, "b": [{"a": "b"}]}"
But I need
"{"a": 1, "b": [{"x": "y"}, {"a": "b"}]}"
How can this be done? PG 9.5
-
1Use the function described in this post: Merging JSONB values in PostgreSQL?klin– klin2017-11-21 19:10:00 +00:00Commented Nov 21, 2017 at 19:10
Add a comment
|