jsonb - jsonb operators

From: Glyn Astill <glynastill(at)yahoo(dot)co(dot)uk>
To: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: jsonb - jsonb operators
Date: 2016-01-15 13:43:39
Message-ID: 1100702023.9060696.1452865419523.JavaMail.yahoo@mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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, "a":4}'::jsonb;
?column?
----------
{"a": 1}
(1 row)

Or would this behaviour be classed as incorrect in some way?

Thanks
Glyn

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2016-01-15 14:03:14 Re: Combining Aggregates
Previous Message Damien Clochard 2016-01-15 11:20:54 Invitation to the OSGEO Code Sprint 2016 / Feb 23-26 in Paris