Re: GSoC 2015: Extra Jsonb functionality

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

In response to

Responses

Browse pgsql-hackers by date

  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?