Thread: NaN behavior

NaN behavior

From
Neil Conway
Date:
postgres=# select 'NaN'::numeric = 'NaN'::numeric,                 'NaN'::float8 = 'NaN'::float8;?column? | ?column? 
----------+----------t        | t
(1 row)

This behavior is inconsistent with most people's notion of "NaN" -- in
particular, it is inconsistent with IEEE754. I can understand why
Postgres behaves this way, and we probably can't easily change it (if we
want to continue indexing NaN values, that is), but I think it should at
least be discussed in the documentation.

Comments? I'll write up a doc patch, barring any objections.

-Neil




Re: NaN behavior

From
Neil Conway
Date:
On Thu, 2007-01-11 at 21:04 -0500, Neil Conway wrote:
> Comments? I'll write up a doc patch, barring any objections.

I'll apply the attached doc patch to CVS tomorrow, barring any
objections.

-Neil


Attachment