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

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: girisa67(at)gmail(dot)com
Subject: BUG #16224: Postgresql - First columnName is where clause has be double brackets?
Date: 2020-01-22 06:15:47
Message-ID: 16224-c4e28f9d8dc0b666@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 16224
Logged by: Girish
Email address: girisa67(at)gmail(dot)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;

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message David G. Johnston 2020-01-22 06:29:42 Re: BUG #16224: Postgresql - First columnName is where clause has be double brackets?
Previous Message PG Bug reporting form 2020-01-22 06:02:40 BUG #16223: Performance regression between 11.6 and 12.1 in an SQL query with a recursive CTE based on function