Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #16636: Upper case issue in JSONB type - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: BUG #16636: Upper case issue in JSONB type
Date
Msg-id CAKFQuwajeSoPwvfcfCiNxGEZZ91xGsNBNzAh9A3mYiKS6dMLGw@mail.gmail.com
Whole thread Raw
In response to Re: BUG #16636: Upper case issue in JSONB type  (ChandraKumar Ovanan <osaimar19@gmail.com>)
Responses Re: BUG #16636: Upper case issue in JSONB type  (ChandraKumar Ovanan <osaimar19@gmail.com>)
List pgsql-bugs
Tree view
On Fri, Sep 25, 2020 at 11:25 PM ChandraKumar Ovanan <osaimar19@gmail.com> wrote:
Hello David,

Thanks a lot, you cleared my question.and it seems fine to me.

You mention boolean type, also the same problem but the document is more clearled. 🙂

Just a suggestion: 
The JSON primitive type is null, The document is not cleared such as lowercase or uppercase.

Please update the document  

pql table.PNG

FWIW, I've proposed a patch [1] but I'm 70-30 whether to cover this material as our documentation doesn't intend to document what is already covered in the RFC and the idea that the value of the null type is spelled (null) is part of the standard.  We document the boolean part because in PostgreSQL inputs for booleans are considerably more liberal.  That all said it doesn't eat up much space and was easy enough to do without being annoying (IMO) so I did it.

David J.

[1] https://www.postgresql.org/message-id/CAHyU1EYRYCV8gELrBYm6V8E%2BToqf%3DKQe370bPt4yrE_Y1yDZ9w%40mail.gmail.com

Attachment

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #16645: pg_upgrade does not mark template1 as a system database
Next
From: "Y. NAKAGAWA"
Date:
Subject: RE: BUG #16645: pg_upgrade does not mark template1 as a system database