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
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?
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 по дате отправления: