Re: Aggregates not allowed in WHERE clause?

Frans <fransgunawan@gmail.com> writes:
> I try to use : select name, sum(quantity) from info where
> sum(quantity)>20 group by name;
> This yields the message: 'Aggregates not allowed in WHERE clause'.

> Can somebody help me here....

See
http://www.postgresql.org/docs/7.4/static/tutorial-agg.html
particularly the next-to-last paragraph.

            regards, tom lane