Re: [HACKERS] NaN behavior

2007-01-12 Thread Neil Conway
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 Index: doc/src/sgml/datatype.sgml

[HACKERS] NaN behavior

2007-01-11 Thread Neil Conway
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