Re: A join of 2 tables with sum(column) > 30

From: Alexander Farber <alexander(dot)farber(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: A join of 2 tables with sum(column) > 30
Date: 2011-03-15 21:45:01
Message-ID: AANLkTikEKTQ59Y62P-ALbpAKUC3MZaGBFcwKE1L_hCe8@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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...
^

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vibhor Kumar 2011-03-15 21:47:46 Re: A join of 2 tables with sum(column) > 30
Previous Message Vibhor Kumar 2011-03-15 21:43:03 Re: A join of 2 tables with sum(column) > 30