On Thu, Dec 16, 2004 at 12:02:34PM +0700, Frans wrote: > 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'.
For aggregates use HAVING, not WHERE: SELECT name, SUM(quantity) FROM info GROUP BY name HAVING SUM(quantity) > 20; http://www.postgresql.org/docs/7.4/static/tutorial-agg.html http://www.postgresql.org/docs/7.4/static/queries-table-expressions.html#QUERIES-GROUP http://www.postgresql.org/docs/7.4/static/sql-select.html -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
