Re: Unexpected numeric comparison result

2004-04-20 Thread Paul DuBois
At 18:47 -0700 4/20/04, Jon Nop wrote: If memory serves me right, a number can not be greater than itself, yet MySQL seems to disagree. mysql> select score,score>7.64 from rateit_files where id=2382; +---++ | score | score>7.64 | +---++ | 7.64 | 1 | +

Unexpected numeric comparison result

2004-04-20 Thread Jon Nop
If memory serves me right, a number can not be greater than itself, yet MySQL seems to disagree. mysql> select score,score>7.64 from rateit_files where id=2382; +---++ | score | score>7.64 | +---++ | 7.64 | 1 | +---++ 1 row in set (0.00 se