Re: BUG #18619: uppercase column with quotation marks, gets an error without quotation marks

Francisco Olarte <folarte@peoplecall.com>

From: Francisco Olarte <folarte@peoplecall.com>
To: gcso@sqliteonline.com, pgsql-bugs@lists.postgresql.org
Date: 2024-09-16T08:41:02Z
Lists: pgsql-bugs
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.