On 19 March 2015 at 14:12, Alvaro Herrera <alvherre@2ndquadrant.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