Thread: BUG #16224: Postgresql - First columnName is where clause has be double brackets?
BUG #16224: Postgresql - First columnName is where clause has be double brackets?
From
PG Bug reporting form
Date:
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;
Re: BUG #16224: Postgresql - First columnName is where clause has bedouble brackets?
From
"David G. Johnston"
Date:
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.
David J.