> -----Original Message----- > From: Alexander Farber [mailto:alexander.farber@xxxxxxxxx] > Sent: Tuesday, March 15, 2011 5:45 PM > To: pgsql-general@xxxxxxxxxxxxxx > 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
