| From: | Dmitry Dolgov <9erthalion6(at)gmail(dot)com> |
|---|---|
| To: | Phillip Haydon <phillip(dot)haydon(at)gmail(dot)com> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: jsonb concatenation loses properties on nested objects |
| Date: | 2016-06-28 17:55:36 |
| Message-ID: | CA+q6zcWHJgZiktOPM+BaMcEQ1ZvdDP=+w8uoqZ2gt7BsQCLGUA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
> Is this by design or is it a bug?
It's by design because `jsonb_concat` is a "shallow concatenation" [1].
Here is a related thread in hackers [2]. "Deep concatenation" functionality
is still to be implemented, but you can use `jsonb_deep_extend` from this
extension [3].
[1]
https://wiki.postgresql.org/wiki/What's_new_in_PostgreSQL_9.5#jsonb_.7C.7C_jsonb_.28concatenate_.2F_overwrite.29
[2]
https://www.postgresql.org/message-id/flat/CAM3SWZRcSp1dS0o5gXeepO7k4QxjjO%2Bh_NsRnCA%3Dmx-OEJ8vYQ%40mail(dot)gmail(dot)com#CAM3SWZRcSp1dS0o5gXeepO7k4QxjjO+h_NsRnCA=mx-OEJ8vYQ(at)mail(dot)gmail(dot)com
[3] https://www.postgresql.org/message-id/55006879.2050601@dunslane.net
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2016-06-28 20:16:22 | Re: BUG #14016: Incomplete documentation of IN subquery expression |
| Previous Message | Phillip Haydon | 2016-06-28 16:44:48 | jsonb concatenation loses properties on nested objects |