From: | Thom Brown <thom(at)linux(dot)com> |
---|---|
To: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
Cc: | Dmitry Dolgov <9erthalion6(at)gmail(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: GSoC 2015: Extra Jsonb functionality |
Date: | 2015-03-19 14:20:36 |
Message-ID: | CAA-aLv783-P_UCTnYzDCkkv6y6gQ0pCUJDfs0+cb854UfCkp+A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On 19 March 2015 at 14:12, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> wrote:
> Dmitry Dolgov wrote:
>
>> * jsonb_slice - extract a subset of an jsonb
>> Example of usage:
>>
>> =# jsonb_slice('{"a": 1, "b": {"c": 2}, "d": {"f": 3}}'::jsonb,
>> ARRAY['b', 'f', 'x']);
>>
>> jsonb_slice
>> ---------------------------
>> {"b": {"c": 2}, "f": 3}
>
> This is a bit strange. Why did "f" get flattened out of "d"? Is the
> resulting document still valid for the purposes of an application using
> it? I think I'd expect the result to be {"b": {"c": 2}, "d": {"f": 3}}
Why would "d" be output when it wasn't in the requested slice?
Although I'm still a bit confused about "f" being produced.
--
Thom
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2015-03-19 14:23:54 | Re: "cancelling statement due to user request error" occurs but the transaction has committed. |
Previous Message | Alvaro Herrera | 2015-03-19 14:17:34 | Re: How about to have relnamespace and relrole? |