Re: Aggregates in WHERE clause? - Mailing list pgsql-sql

From Tom Lane
Subject Re: Aggregates in WHERE clause?
Date
Msg-id 16867.1221134603@sss.pgh.pa.us
Whole thread Raw
In response to Re: Aggregates in WHERE clause?  ("Richard Broersma" <richard.broersma@gmail.com>)
List pgsql-sql
"Richard Broersma" <richard.broersma@gmail.com> writes:
> On Wed, Sep 10, 2008 at 4:11 PM, Ruben Gouveia <rubes7202@gmail.com> wrote:
>> ERROR:  aggregates not allowed in WHERE clause

> Having clause works on agregates.  If you want to force it in the
> where, you need to put the groupby in a sub-query.

The way I like to think about it is "WHERE filters rows before aggregate
functions are computed; HAVING filters them afterwards".  Seen in those
terms, it's obvious why WHERE can't contain any aggregates.
        regards, tom lane


pgsql-sql by date:

Previous
From: Craig Ringer
Date:
Subject: Re: pg_restore in java connection (auto_commit = false)
Next
From: "Igor Neyman"
Date:
Subject: Re: Aggregates in WHERE clause?