Re: [GENERAL] Anomaly with SUM().

[Anthony Best]

Stephan Szabo wrote:

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.
 

It's "double precision." (Which is float8?).

So, should I tweak my join to preserve order, or something else?



---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
     subscribe-nomail command to [EMAIL PROTECTED] so that your
     message can get through to the mailing list cleanly