Horton

Re: min() and NaN

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

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Jean-Luc Lachance <jllachan@nsd.ca>
Cc: "Michael S. Tibbetts" <mtibbetts@head-cfa.cfa.harvard.edu>, pgsql-sql@postgresql.org
Date: 2003-07-21T15:43:19Z
Lists: pgsql-sql 
Jean-Luc Lachance <jllachan@nsd.ca> writes:
> If a compare with NaN is always false, how about rewriting it as:
> result = ((arg1 < arg2) ? arg2 : arg1).

That just changes the failure mode.

			regards, tom lane