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.
---------------------------(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
