Postgres Pro
Downloads
Home   >   mailing lists

Re: Aggregate Aggravation - Mailing list pgsql-sql

From Tom Lane
Subject Re: Aggregate Aggravation
Date
Msg-id 2193.1001611912@sss.pgh.pa.us
Whole thread Raw
In response to Aggregate Aggravation  ("Robin's PG-SQL List" <pg-sql@mail.robin.net>)
Responses Re: Aggregate Aggravation
List pgsql-sql
Tree view 
"Robin's PG-SQL List" <pg-sql@mail.robin.net> 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

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: A bug in triggers PG 7.1.3 or misunderstand ?
Next
From: "Josh Berkus"
Date:
Subject: Re: LEFT OUTER JOIN problem