Tom Lane writes:
> [ continuing a discussion from last August ]
[I was *just* thinking about this. Funny.]
> I believe that's not a problem anymore. The current form of the float
> comparison functions will perform sorting and comparisons according to
> the sequence
>
> -infinity < normal values < infinity < NaN < NULL
I was thinking about making NaN equivalent to NULL. That would give
consistency in ordering, and probably also in arithmetic. Additionally,
if the platform supports it we ought to make the Invalid Operation FP
exception (which yields NaN) configurable: either get NULL or get an
error.
--
Peter Eisentraut peter_e@gmx.net http://funkturm.homeip.net/~peter