Received: from br1.brwholesale.com (br1.brwholesale.com [216.47.250.2]) by postgresql.org (Postfix) with ESMTP id 43BB447517F for ; Fri, 19 Apr 2002 15:24:59 -0400 (EDT) Received: from ws20.brwholesale.com (ws20.brwholesale.com [10.4.13.20]) by br1.brwholesale.com (Postfix) with ESMTP id 871AF542C for ; Fri, 19 Apr 2002 15:24:48 -0400 (EDT) Message-Id: <5.1.0.14.2.20020419152136.00b50938@imap.brwholesale.com> X-Sender: mhagerty@imap.brwholesale.com X-Mailer: QUALCOMM Windows Eudora Version 5.1 Date: Fri, 19 Apr 2002 15:24:48 -0400 To: pgsql-sql@postgresql.org From: Matthew Hagerty Subject: Query Praise! Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-Archive-Number: 200204/252 X-Sequence-Number: 7516 Haha, Tom Lane (and all the pg developers), you ROCK! Thanks a million!!! These kinds of queries save my ass! select sum(score) from (select distinct on (question_id) score from answers where score is not null order by question_id,score) as score; Matthew