[EMAIL PROTECTED] wrote:
>
[blabla because there is no sql in my text]
>
> You have written the following:
>
> Good point
>
> well then the best is two smaller than the highest "resolution" you
> have.
>
> if all your data has 4 digits after the . you'll be ok with a epsilon 2
> digits smaller since you're sure that it won't affect the 4th digit
> after the .
>
> Etienne
>
> Shankar Unni wrote:
> >
> > Etienne Marcotte wrote:
> >
> > > maybe you can add a small value to be sure it rounds up.
> > >
> > > select round(9.065+.001,2);
> > >
> > > Always add 1 at the digit after the one you want to keep:)
> > >
> > > so 9.065 can also be a variable...
> > >
> > > Etienne
> > >
> > > Shankar Unni wrote: [Long-winded IEEE float explanation :-)]
> >
> > That's a reasonable solution, though you have to be sure to add a *really*
> > small "epsilon" (as small as you can reasonably represent in source code).
> >
> > The danger with a large epsilon like "0.001" is that 9.4995 will round as
> > 10 instead of 9, even though it's clearly smaller than 9.5. Some people may
> > care :-).
> >
> > --
> > Shankar.
>
> --
> Etienne Marcotte
> Specifications Management - Quality Control
> Imperial Tobacco Ltd. - Montreal (Qc) Canada
> 514.932.6161 x.4001
--
Etienne Marcotte
Specifications Management - Quality Control
Imperial Tobacco Ltd. - Montreal (Qc) Canada
514.932.6161 x.4001
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php