Re: Anomaly with SUM(). - Mailing list pgsql-general

From Stephan Szabo
Subject Re: Anomaly with SUM().
Date
Msg-id 20030808121849.M77201-100000@megazone.bigpanda.com
Whole thread Raw
In response to Anomaly with SUM().  (Anthony Best <abest@digitalflex.net>)
Responses Re: Anomaly with SUM().  (Anthony Best <abest@digitalflex.net>)
List pgsql-general
On Fri, 8 Aug 2003, Anthony Best wrote:

> I've noticed that the SUM() seems to overflow under some situations.
>
> The only difference is the order that the data is retrived from the
> database.

Is amount a float type column (float4 or float8)? If so, you're probably
just running into issues with float precision problems.  Changing the
order of the operations can change the final value of a sequence of
operations on float.


pgsql-general by date:

Previous
From: Dennis Gearon
Date:
Subject: Re: Anomaly with SUM().
Next
From: Tom Lane
Date:
Subject: Re: Anomaly with SUM().