Frans <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
