> -----Original Message-----
> From: Alexander Farber [mailto:alexander.farber@gmail.com]
> Sent: Tuesday, March 15, 2011 5:45 PM
> To: pgsql-general@postgresql.org
> Subject: Re: A join of 2 tables with sum(column) > 30
>
> And same for a simple select-query from1 table (w/o join):
>
> # select id from pref_match where sum(completed) > 30 group by id;
> ERROR: aggregates not allowed in WHERE clause LINE 1: select
> id from pref_match where sum(completed) > 30 group by...
> ^
>
You should "HAVING" close (not "WHERE") for an aggregate as a condition:
Select id, sum(col1) from tab
Where id > 10
Group by id
Having sum)col1) >30;
Spend some time reading basic SQL docs/books - it'll help you
tremendously.
Regards,
Igor Neyman