Re: greatest/least semantics different between oracle and postgres

Поиск
Список
Период
Сортировка
От Ben
Тема Re: greatest/least semantics different between oracle and postgres
Дата
Msg-id BEF0BBEC-B458-4EE9-853A-608BCB096B9C@silentmedia.com
обсуждение исходный текст
Ответ на Re: greatest/least semantics different between oracle and postgres  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: greatest/least semantics different between oracle and postgres  ("paul rivers" <rivers.paul@gmail.com>)
Re: greatest/least semantics different between oracle and postgres  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Дерево обсуждения 
On Jun 29, 2007, at 9:15 PM, Tom Lane wrote:

> Hmm ... I fear Oracle's behavior is more correct, because if any
> argument is null (ie, unknown), then who can say what the greatest or
> least value is?  It's unknown (ie, null).  But I suspect our behavior
> is more useful.  Comments?

I agree with you. I don't know what the spec says, but it seems clear
Oracle is doing the proper thing and Postgres is doing the useful thing.

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

Предыдущее
От: Aly Dharshi
Дата:
Сообщение: Sun Cluster and PGSQL
Следующее
От: "paul rivers"
Дата:
Сообщение: Re: greatest/least semantics different between oracle and postgres