On 15 Mar 2011, at 22:33, Alexander Farber wrote: > I'm trying to change it to a sum, but get the error: > > # select u.id, u.first_name, sum(m.completed) > from pref_users u, pref_match m > where u.id=m.id and u.id like 'DE%' and > sum > 30 group by u.id, u.first_name > order by sum desc limit 3;
# select u.id, u.first_name, sum(m.completed) from pref_users u, pref_match m where u.id=m.id and u.id like 'DE%' group by u.id, u.first_name having sum(m.completed) > 30 order by sum desc limit 3; Alban Hertroys -- If you can't see the forest for the trees, cut the trees and you'll see there is no forest. !DSPAM:737,4d80686f235882980188992! -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
