Cariotoglou Mike wrote: > > I see again that you all miss the point. I DO know how to handle floating > point. My point is : > ... > > since a solution to this issue is fairly simple, and the applicable audience > is large, why not provide one? > the fact that MSSQL will not be able to do the same is not an argument that > has stopped drh before, has it. >
Now you are missing the point :). The solution is not all that simple. Perhaps the "best" approach is to allow for "fuzzy" comparisons. I refer you to http://ftp.cac.psu.edu/pub/ger/fortran/hdk/eps.f90 (or .for) for more information and an implementation of an algorithm that has proven its usefulness. (Don't take it too lightly: according to the author/transcriber it is the result of long discussions and disputes in at least one language community). Your proposal could be used to set the tolerance for the fuzzy comparison. Scaling issues are then taken care of by that algorithm (I should have thought of it before....) Regards, Arjen