Simple aggregate query brain fart

Поиск
Список
Период
Сортировка
От Mark Fenbers
Тема Simple aggregate query brain fart
Дата
Msg-id 4BA24184.7060603@noaa.gov
обсуждение исходный текст
Ответ на Re: Postgresql format for ISO8601  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Simple aggregate query brain fart  ("Plugge, Joe R." <JRPlugge@west.com>)
Re: Simple aggregate query brain fart  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-sql
I want to do:

SELECT id, count(*) FROM mytable WHERE count(*) > 2 GROUP BY id;

But this doesn't work because Pg won't allow aggregate functions in a
where clause.  So I modified it to:

SELECT id, count(*) AS cnt FROM mytable WHERE cnt > 2 GROUP BY id;

But Pg still complains (that column cnt does not exist).  When using an
GROUP/ORDER BY clause, I can refer to a column number (e.g., GROUP BY 1)
instead of a column name, but how can I refer to my unnamed second
column in my where clause?

Mark


Вложения

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

Предыдущее
От: silly sad
Дата:
Сообщение: Re: MSSQL to PostgreSQL - Issue trying to generate unique ID using actual date
Следующее
От: "Plugge, Joe R."
Дата:
Сообщение: Re: Simple aggregate query brain fart