Re: min() and NaN

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: min() and NaN
Дата
Msg-id 4074.1058854149@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: min() and NaN  (Bruce Momjian <pgman@candle.pha.pa.us>)
Ответы Re: min() and NaN  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: min() and NaN  (Michael Tibbetts <tibbetts@head-cfa.harvard.edu>)
Список pgsql-sql
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Is this a TODO?

It'll only take ten minutes to make it a DONE, once we figure out what
the behavior ought to be.  So far I think both Stephan and I argued that
MIN/MAX ought to treat NaN as larger than all ordinary values, for
consistency with the comparison operators.  That was not the behavior
Michael wanted, but I don't see that we have much choice given the
wording of the SQL spec.  Does anyone want to argue against that
definition?
        regards, tom lane


В списке pgsql-sql по дате отправления:

Предыдущее
От: Wolfgang Slany
Дата:
Сообщение: Re: "Truncate [ Table ] name [Cascade]"?
Следующее
От: "Girish Bajaj"
Дата:
Сообщение: time delay function