Re: BUG #16224: Postgresql - First columnName is where clause has bedouble brackets?

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: BUG #16224: Postgresql - First columnName is where clause has bedouble brackets?
Дата
Msg-id CAKFQuwZswj2_HuB66LN+dF28PReXA0CEsGE3Gc1h69vqCFJUFw@mail.gmail.com
обсуждение исходный текст
Ответ на BUG #16224: Postgresql - First columnName is where clause has be double brackets?  (PG Bug reporting form <noreply@postgresql.org>)
Список pgsql-bugs
Дерево обсуждения
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.

В списке pgsql-bugs по дате отправления:

Предыдущее
От: PG Bug reporting form
Дата:
Сообщение: BUG #16224: Postgresql - First columnName is where clause has be double brackets?
Следующее
От: PG Bug reporting form
Дата:
Сообщение: BUG #16225: EL8 - PGDG postgresql* packages conflict with appstream postgresql packages