Re: GSoC 2015: Extra Jsonb functionality

From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: Dmitry Dolgov <9erthalion6(at)gmail(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: GSoC 2015: Extra Jsonb functionality
Date: 2015-03-19 14:12:55
Message-ID: 20150319141255.GD3636@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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}}

--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2015-03-19 14:17:34 Re: How about to have relnamespace and relrole?
Previous Message Thom Brown 2015-03-19 14:07:35 Re: GSoC 2015: Extra Jsonb functionality