Subject | Re: [firebird-support] Re: INTEGER BUG |
---|---|
Author | Dimitry Sibiryakov |
Post date | 2009-05-05T13:22:29Z |
> How can I anticipate when this error will occour.Because this is arithmetic rules. When you multiple 1.5 and 1.5
>
> Why do the precisions ADD when i multiply...?
you'll get 2.25, not 2.2 or 2.25013.
> What is my solution ?If you don't need _precise_ arithmetic, cast one of numbers to DOUBLE
PRECISION to get imprecise floating-point result.
SY, SD.