On Wed, 10 Sep 2008, Ruben Gouveia wrote:
> 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
You probably want to look at some variant with HAVING, assuming you intend
those max()s to be based on the employee groups.
In response to
pgsql-sql by date
|Next:||From: Richard Broersma||Date: 2008-09-10 23:59:49|
|Subject: Re: Aggregates in WHERE clause?|
|Previous:||From: Ruben Gouveia||Date: 2008-09-10 23:11:13|
|Subject: Aggregates in WHERE clause?|