Postgres Pro
Downloads
Home   >   mailing lists

Re: min() and NaN - Mailing list pgsql-sql

From Tom Lane
Subject Re: min() and NaN
Date
Msg-id 5212.1058802199@sss.pgh.pa.us
Whole thread Raw
In response to Re: min() and NaN  (Jean-Luc Lachance <jllachan@nsd.ca>)
Responses Re: min() and NaN  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Jean-Luc Lachance
Date:
Subject: Re: min() and NaN
Next
From: "Cristian Cappo A."
Date:
Subject: Re: How access to array component