"Zeugswetter Andreas SB SD" <[EMAIL PROTECTED]> writes:
> For above calculation pg will in the future return 0.00000000000000000000 as an
> answer to 1.00000000000001*1000.0-1000.0 when used in my example context, while
> it currently returns 0.000000000010 ...
> You both are saying, that 0.00000000000000000000 is a better answer.
Not exactly: we are saying it is not a worse answer. There's no reason
to prefer one over the other, because they are both within the range
of uncertainty given the inherent uncertainty in the float4 input.
If you want exact results, you should be using exact datatypes.
regards, tom lane
---------------------------(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
