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/
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных