Re: jsonb contains behaviour weirdness - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: jsonb contains behaviour weirdness
Date
Msg-id 54171D0C.8070802@agliodbs.com
Whole thread Raw
In response to jsonb contains behaviour weirdness  (Alexander Korotkov <aekorotkov@gmail.com>)
Responses Re: jsonb contains behaviour weirdness  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On 09/12/2014 01:33 PM, Tom Lane wrote:
> Josh Berkus <josh@agliodbs.com> writes:
>> However, this better become a FAQ item, because it's not necessarily the
>> behavior that folks used to JSON but not Postgres will expect.
> 
> No, it's a bug, not a documentation deficiency.

Hmmm?  Are you proposing that we should change how ARRAY @> ARRAY works
for non-JSON data?

Or are you proposing that JSONARRAY @> JSONARRAY should work differently
from ARRAY @> ARRAY?

Or are you agreeing with Peter that it's the first case that's a bug,
and the 2nd two tests are correct, and just being unclear?

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: pgbench throttling latency limit
Next
From: Josh Berkus
Date:
Subject: Re: jsonb format is pessimal for toast compression