Received: from mail1.hub.org (webmail.hub.org [216.126.85.1]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f8RHiOh83391 for ; Thu, 27 Sep 2001 13:44:24 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss.pgh.pa.us ([192.204.191.242]) by mail1.hub.org (8.11.3/8.11.4) with ESMTP id f8RHWNS81321 for ; Thu, 27 Sep 2001 13:32:23 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.4/8.11.4) with ESMTP id f8RHVqK02196; Thu, 27 Sep 2001 13:31:52 -0400 (EDT) To: "Robin's PG-SQL List" cc: pgsql-sql@postgresql.org Subject: Re: Aggregate Aggravation In-reply-to: References: Comments: In-reply-to "Robin's PG-SQL List" message dated "Wed, 26 Sep 2001 15:43:51 -0700" Date: Thu, 27 Sep 2001 13:31:52 -0400 Message-ID: <2193.1001611912@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200109/263 X-Sequence-Number: 4945 "Robin's PG-SQL List" writes: > I have a query using the SUM() function that is not returning the > appropriate results. I'm guessing that you have two rows in bolcustomer matching bol_number = 88738, so that the 14 gets added in twice. regards, tom lane