On Tue, Oct 28, 2003 at 21:16:53 +0100,
SZUCS Gábor <[EMAIL PROTECTED]> wrote:
>
> As Tom pointed out, it isn't a floating point failure -- it is how rounding
> float is implemented. I assume anything with less than 15 digits can be
> exactly represented as float.
No. It has to be a dyadic number. For example .3 will not be represented
exactly by a float.
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
