Re: jsonb contains behaviour weirdness

From: Peter Geoghegan <pg(at)heroku(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Alexander Korotkov <aekorotkov(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: jsonb contains behaviour weirdness
Date: 2014-09-12 18:14:22
Message-ID: CAM3SWZT+7DJ8y4cPZmji-qbpPrUjmATBhPVHRV0t6=5V7YfgVA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Sep 12, 2014 at 11:09 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> I'm confused. Are you proposing to return to sort + de-dup of JSON
> arrays? Surely that is completely broken. Arrays are ordered.

Sorry, my earlier remarks were premature. In fact, that alteration
only applied to existence, not containment. However, arrays are
ordered for the purposes of equality, but not containment.

--
Peter Geoghegan

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Josh Berkus 2014-09-12 18:21:41 Re: jsonb contains behaviour weirdness
Previous Message Tom Lane 2014-09-12 18:09:11 Re: jsonb contains behaviour weirdness