Re: [HACKERS] jsonb - jsonb operators

2016-01-19 Thread Merlin Moncure
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

Re: [HACKERS] jsonb - jsonb operators

2016-01-18 Thread Vitaly Burovoy
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. > > >

Re: [HACKERS] jsonb - jsonb operators

2016-01-18 Thread Glyn Astill
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

Re: [HACKERS] jsonb - jsonb operators

2016-01-18 Thread Tom Lane
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

Re: [HACKERS] jsonb - jsonb operators

2016-01-17 Thread Dmitry Dolgov
> 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

Re: [HACKERS] jsonb - jsonb operators

2016-01-15 Thread Glyn Astill
- 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

Re: [HACKERS] jsonb - jsonb operators

2016-01-15 Thread Merlin Moncure
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"

[HACKERS] jsonb - jsonb operators

2016-01-15 Thread Glyn Astill
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,