Re: Rounding

At 13:34 +0100 10/13/04, Scott Simpson wrote:
>Dear All,
>
>
>
>If I create a simple table with a single column of type FLOAT and I
>insert 2 values say 5.8 and 5.9.
>
>
>
>When I issue 'SELECT * FROM t_table where f_float > 5.8, I get what I
>expect.
>
>
>
>When I issue 'SELECT * FROM t_table where f_float < 5.9, I get what I
>expect.
>
>
>
>When I issue 'SELECT * FROM t_table where f_float >= 5.8 I get what I
>expect.
>
>
>
>When I issue 'SELECT * FROM t_table where f_float <= 5.9, I only get 1
>row returned (i.e. 5.8 and not 5.9, which is not what I expect).
>
>
>
>Did I miss something?


http://dev.mysql.com/doc/mysql/en/Problems_with_float.html

-- 
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com

-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/[email protected]