| From: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com> |
|---|---|
| To: | Robert Haas <robertmhaas(at)gmail(dot)com> |
| Cc: | Nikita Glukhov <n(dot)gluhov(at)postgrespro(dot)ru>, PostgreSQL mailing lists <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Bug in comparison of empty jsonb arrays to scalars |
| Date: | 2016-11-09 22:15:45 |
| Message-ID: | CAB7nPqSDa=WDEVQ2oQyfiNJmpQKWJQDvxS2kG29fyQtdk5eUdQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Thu, Nov 10, 2016 at 3:27 AM, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
> On Tue, Nov 8, 2016 at 9:49 PM, Michael Paquier
> <michael(dot)paquier(at)gmail(dot)com> wrote:
>> On Wed, Nov 9, 2016 at 8:31 AM, Nikita Glukhov <n(dot)gluhov(at)postgrespro(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2016-11-09 22:37:37 | Re: Bug in comparison of empty jsonb arrays to scalars |
| Previous Message | Marc Balmer | 2016-11-09 22:05:48 | Referential integrity on large objects |