Re: Anomaly with SUM().

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?