Re: Aggregates in WHERE clause?

Поиск
Список
Период
Сортировка
От Igor Neyman
Тема Re: Aggregates in WHERE clause?
Дата
Msg-id F4C27E77F7A33E4CA98C19A9DC6722A2037201FB@EXCHANGE.corp.perceptron.com
обсуждение исходный текст
Ответ на Aggregates in WHERE clause?  ("Ruben Gouveia" <rubes7202@gmail.com>)
Список pgsql-sql
select employee,count(distinct tasks), greatest(max(last_job_date),max(last_position_date)) 
        from job
        group by employee
        having greatest(max(last_job_date),max(last_position_date)) < 2008-08-28 + integer '1';



From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org] On Behalf Of Ruben Gouveia
Sent: Wednesday, September 10, 2008 7:11 PM
To: pgsql-sql
Subject: [SQL] Aggregates in WHERE clause?

I tried to do the following and got the following error message:

select employee,count(distinct tasks)
        from job
        where greatest(max(last_job_date),max(last_position_date)) < 2008-08-28 + integer '1'
        group by employee;

ERROR:  aggregates not allowed in WHERE clause

********** Error **********

ERROR: aggregates not allowed in WHERE clause
SQL state: 42803


Is there away around this? Should i create a function to populate a variable that can be used in it's place...will that even work?


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Aggregates in WHERE clause?
Следующее
От: Emi Lu
Дата:
Сообщение: Re: pg_restore in java connection (auto_commit = false)