Re: min() and NaN

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Greg Stark <gsstark@mit.edu>
Cc: Bruce Momjian <pgman@candle.pha.pa.us>, Stephan Szabo <sszabo@megazone.bigpanda.com>, Jean-Luc Lachance <jllachan@nsd.ca>, "Michael S. Tibbetts" <mtibbetts@head-cfa.cfa.harvard.edu>, pgsql-sql@postgresql.org
Date: 2003-07-24T18:44:10Z
Lists: pgsql-sql
Greg Stark <gsstark@mit.edu> writes:
> Does postgres intend to support all the different types of NaN? Does you
> intend to have +Inf and -Inf and underflow detection and all the other goodies
> you actually need to make it useful?

We have some of that; it needs work, and it's always going to be
dependent on the platform having proper IEEE support, but that's no
excuse to throw it away.

			regards, tom lane