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)
Список
Дерево обсуждения
greatest/least semantics different between oracle and postgres Bruno Wolff III <bruno@wolff.to>
Re: greatest/least semantics different between oracle and postgres "Pavel Stehule" <pavel.stehule@gmail.com>
Re: greatest/least semantics different between oracle and postgres Bruno Wolff III <bruno@wolff.to>
Re: greatest/least semantics different between oracle and postgres "Pavel Stehule" <pavel.stehule@gmail.com>
Re: greatest/least semantics different between oracle and postgres "paul rivers" <rivers.paul@gmail.com>
Re: greatest/least semantics different between oracle and postgres "paul rivers" <rivers.paul@gmail.com>
Re: greatest/least semantics different between oracle and postgres "Pavel Stehule" <pavel.stehule@gmail.com>
Re: greatest/least semantics different between oracle and postgres Robert Treat <xzilla@users.sourceforge.net>
Re: greatest/least semantics different between oracle and postgres "Andrej Ricnik-Bay" <andrej.groups@gmail.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 Bruno Wolff III <bruno@wolff.to>
Re: greatest/least semantics different between oracle and postgres Gregory Stark <stark@enterprisedb.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 Gregory Stark <stark@enterprisedb.com>
Re: greatest/least semantics different between oracle and postgres "Andrej Ricnik-Bay" <andrej.groups@gmail.com>
Re: greatest/least semantics different between oracle and postgres Ben <bench@silentmedia.com>
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>
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>
Re: greatest/least semantics different between oracle and postgres Gregory Stark <stark@enterprisedb.com>
Re: greatest/least semantics different between oracle and postgres Bruce Momjian <bruce@momjian.us>
Re: greatest/least semantics different between oracle and postgres Gregory Stark <stark@enterprisedb.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 "Pavel Stehule" <pavel.stehule@gmail.com>
Re: greatest/least semantics different between oracle and postgres Bruce Momjian <bruce@momjian.us>
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 Bruce Momjian <bruce@momjian.us>
Re: greatest/least semantics different between oracle and postgres "John D. Burger" <john@mitre.org> 
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
Дата:
FAQ