BUG #16224: Postgresql - First columnName is where clause has be double brackets?

Started by PG Bug reporting formover 6 years ago2 messagesbugs
Jump to latest
#1PG Bug reporting form
noreply@postgresql.org

The following bug has been logged on the website:

Bug reference: 16224
Logged by: Girish
Email address: girisa67@gmail.com
PostgreSQL version: 10.0
Operating system: Windows 10
Description:

Hi,

In Postgresql SELECT query first columnName should be enclosed with in
double quotes("columnname") and second column not required to enclose in
double quotes. Is that a bug with postgresql?

SELECT DISTINCT * FROM tabelName WHERE "CommodityId" = 1 AND column2 = 1;

#2David G. Johnston
david.g.johnston@gmail.com
In reply to: PG Bug reporting form (#1)
Re: BUG #16224: Postgresql - First columnName is where clause has be double brackets?

On Tuesday, January 21, 2020, PG Bug reporting form <noreply@postgresql.org>
wrote:

The following bug has been logged on the website:

Bug reference: 16224
Logged by: Girish
Email address: girisa67@gmail.com
PostgreSQL version: 10.0
Operating system: Windows 10
Description:

Hi,

In Postgresql SELECT query first columnName should be enclosed with in
double quotes("columnname") and second column not required to enclose in
double quotes. Is that a bug with postgresql?

SELECT DISTINCT * FROM tabelName WHERE "CommodityId" = 1 AND column2 = 1;

Don’t really understand the question but its probably not a bug.

https://www.postgresql.org/docs/12/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS

David J.