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.