Re: Aggregates in WHERE clause?

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: Ruben Gouveia <rubes7202(at)gmail(dot)com>
Cc: pgsql-sql <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Aggregates in WHERE clause?
Date: 2008-09-10 23:19:58
Message-ID: 20080910161537.Q33198@megazone.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Broersma 2008-09-10 23:59:49 Re: Aggregates in WHERE clause?
Previous Message Ruben Gouveia 2008-09-10 23:11:13 Aggregates in WHERE clause?