Re: Why no min / max

On Nov 26, 10:58 pm, Tom St Denis <t...@xxxxxxx> wrote:
On Nov 26, 10:54 am, Eric Sosman <esos...@xxxxxxxxxxxxxxxxxxxx> wrote:
... MIN(NaN,42) could yield 42, while MIN(42,NaN) could yield NaN.
I think most
people would find a non-commutative MIN surprising ...

Simple just do MIN(MIN(x,y),MIN(y,x)).

Solved.

Try again. In the hypothetical (x=42, y=NaN)
MIN(MIN(x,y),MIN(y,x)) != MIN(MIN(y,x),MIN(x,y))

James
.

Quantcast