Re: Bug in comparison of empty jsonb arrays to scalars - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: Bug in comparison of empty jsonb arrays to scalars
Date
Msg-id CAB7nPqSDa=WDEVQ2oQyfiNJmpQKWJQDvxS2kG29fyQtdk5eUdQ@mail.gmail.com
Whole thread Raw
In response to Re: Bug in comparison of empty jsonb arrays to scalars  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Bug in comparison of empty jsonb arrays to scalars  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Thu, Nov 10, 2016 at 3:27 AM, Robert Haas <robertmhaas@gmail.com> wrote:
> On Tue, Nov 8, 2016 at 9:49 PM, Michael Paquier
> <michael.paquier@gmail.com> wrote:
>> On Wed, Nov 9, 2016 at 8:31 AM, Nikita Glukhov <n.gluhov@postgrespro.ru> wrote:
>>> Hi hackers.
>>>
>>> While working on jsonbstatistics, I found the following bug:
>>> an empty jsonb array is considered to be lesser than any scalar,
>>> but it is expected that objects > arrays > scalars.
>>
>> Sources?
>
> How about "our documentation"?
>
> https://www.postgresql.org/docs/current/static/datatype-json.html

Indeed, I missed that. So that's broken...
-- 
Michael



pgsql-hackers by date:

Previous
From: Marc Balmer
Date:
Subject: Referential integrity on large objects
Next
From: Tom Lane
Date:
Subject: Re: Bug in comparison of empty jsonb arrays to scalars