On Wed, Jun 9, 2010 at 3:56 PM, Jim Meyering <[email protected]> wrote: > > When comparing floating point numbers how would join measure equality? > Should it consider 1.000000000000001e2 to be equal to 100.0 ? > What if the maximum precision available does not > allow us to distinguish those two values?
Indeed, that's why you generally don't use floating point numbers as database keys. We could either restrict the numbers to integers, or continue to allow floats with a note to the effect that float precision is machine-specific. Personally I have no need for floats so am happy with the former. -- Alex
