Received: from mail1.hub.org (webmail.hub.org [216.126.85.1]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f8T65UO86521 for ; Sat, 29 Sep 2001 02:05:34 -0400 (EDT) (envelope-from pg-sql@mail.robin.net) Received: from mail.robin.net ([65.208.159.4]) by mail1.hub.org (8.11.3/8.11.4) with ESMTP id f8S5tsS32630 for ; Fri, 28 Sep 2001 01:55:55 -0400 (EDT) (envelope-from pg-sql@mail.robin.net) Received: from localhost (pg-sql@localhost) by mail.robin.net (8.8.7/8.8.7) with SMTP id XAA07999; Thu, 27 Sep 2001 23:33:07 -0700 Date: Thu, 27 Sep 2001 23:33:06 -0700 (MST) From: "Robin's PG-SQL List" To: Tom Lane cc: pgsql-sql@postgresql.org Subject: Re: Aggregate Aggravation In-Reply-To: <2193.1001611912@sss.pgh.pa.us> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200110/17 X-Sequence-Number: 4972 Indeed I do. I need to add another constraint on that query. It never would have occurred to me had I not asked. Problem solved. Thank you, thank you! -Robin On Thu, 27 Sep 2001, Tom Lane wrote: > "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 > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html >