On Mon, Jan 18, 2016 at 10:50 AM, Tom Lane wrote:
> Dmitry Dolgov <9erthali...@gmail.com> writes:
>>> if there's any future intention to add a delete operator that removes
>> element/pair matches?
>
>> I think the operator (jsonb - jsonb) is logical because we have a shallow
>> concatenation funct
On 1/15/16, Glyn Astill wrote:
> Hi all,
>
> I was just looking through the new jsonb operators in the 9.5 release, and
> was wondering if there's any future intention to add a delete operator that
> removes element/pair matches? I.e. some sort of top-level "jsonb - jsonb"
> operator, e.g.
>
>
>
On Mon, 18/1/16, Tom Lane wrote:
Subject: Re: [HACKERS] jsonb - jsonb operators
To: "Dmitry Dolgov" <9erthali...@gmail.com>
Cc: "Glyn Astill" , "Merlin Moncure"
, "pgsql-hackers@postgresql.org"
D
Dmitry Dolgov <9erthali...@gmail.com> writes:
>> if there's any future intention to add a delete operator that removes
> element/pair matches?
> I think the operator (jsonb - jsonb) is logical because we have a shallow
> concatenation function (something like a "union" operation), but we have
> no
> if there's any future intention to add a delete operator that removes
element/pair matches?
I think the operator (jsonb - jsonb) is logical because we have a shallow
concatenation function (something like a "union" operation), but we have
nothing like "set difference" and "intersection" functio
- Original Message -
> From: Merlin Moncure
> To: Glyn Astill
> Cc: "pgsql-hackers@postgresql.org"
> Sent: Friday, 15 January 2016, 14:50
> Subject: Re: [HACKERS] jsonb - jsonb operators
>
> On Fri, Jan 15, 2016 at 7:43 AM, Glyn Astill
> wro
On Fri, Jan 15, 2016 at 7:43 AM, Glyn Astill wrote:
> Hi all,
>
> I was just looking through the new jsonb operators in the 9.5 release, and
> was wondering if there's any future intention to add a delete operator that
> removes element/pair matches? I.e. some sort of top-level "jsonb - jsonb"
Hi all,
I was just looking through the new jsonb operators in the 9.5 release, and was
wondering if there's any future intention to add a delete operator that removes
element/pair matches? I.e. some sort of top-level "jsonb - jsonb" operator,
e.g.
# select '{"a":1, "b":2}'::jsonb - '{"b":2,