John Stanton wrote: > > The point about using floating point is that there is no equal, only > less or greater, because it is an approximation. If you want to use > equality you must use some form of integer or fixed ppint numbers. >
That's not true at all. While it is not reliable to use equality tests for different floating point numbers, there is very definitely the possibility of two floating point numbers being equal. For any two floating point numbers with the same bit pattern, both < and > will be false. All code using floating point numbers must be able to handle the equal case correctly, it is usually just merged with one of the < or > cases. That is what Steve's correction was. He suggested it should merge the equal case with the < case. It usually makes no sense to merge the < and > cases (this is simply another way to say not equal) as it was originally documented. Dennis Cote _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users