Postgres Pro
Downloads
Home   >   mailing lists

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

From PG Bug reporting form
Subject BUG #16224: Postgresql - First columnName is where clause has be double brackets?
Date
Msg-id 16224-c4e28f9d8dc0b666@postgresql.org
Whole thread Raw
Responses Re: BUG #16224: Postgresql - First columnName is where clause has bedouble brackets?  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-bugs
Tree view 
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;

pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #16223: Performance regression between 11.6 and 12.1 in an SQL query with a recursive CTE based on function
Next
From: "David G. Johnston"
Date:
Subject: Re: BUG #16224: Postgresql - First columnName is where clause has bedouble brackets?