[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
bug#6366: join can't join on numeric fields
From: |
Alex Shinn |
Subject: |
bug#6366: join can't join on numeric fields |
Date: |
Wed, 9 Jun 2010 16:33:06 +0900 |
On Wed, Jun 9, 2010 at 3:56 PM, Jim Meyering <address@hidden> 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