Request a Demo
Home   >   mailing lists

Re: BUG #18619: uppercase column with quotation marks, gets an error without quotation marks - Mailing list pgsql-bugs

From Francisco Olarte
Subject Re: BUG #18619: uppercase column with quotation marks, gets an error without quotation marks
Date
Msg-id CA+bJJbyoF=sRMcpzuAxwQDxp7YEJND=kQCzqn4a7yJtFRj7sbg@mail.gmail.com
Whole thread Raw
In response to BUG #18619: uppercase column with quotation marks, gets an error without quotation marks  (PG Bug reporting form <noreply@postgresql.org>)
List pgsql-bugs
Tree view 
On Mon, 16 Sept 2024 at 09:42, PG Bug reporting form
<noreply@postgresql.org> wrote:
> The following bug has been logged on the website:
> If you create a table with field names in uppercase and put them in
> quotation marks.
> then such fields can be accessed only with quotation marks.

Not a bug, but a long known std deviation. Read
https://www.postgresql.org/docs/17/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS
. You would have the same problem with std swapping upper and lower.

Francisco Olarte.

pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #18619: uppercase column with quotation marks, gets an error without quotation marks
Next
From: Francisco Olarte
Date:
Subject: Re: BUG #18619: uppercase column with quotation marks, gets an error without quotation marks