Re: Nulls in timestamps

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Nulls in timestamps
Дата
Msg-id 1121278558.8208.257.camel@state.g2switchworks.com
обсуждение исходный текст
Ответ на Re: Nulls in timestamps  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Nulls in timestamps  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
On Wed, 2005-07-13 at 12:41, Tom Lane wrote:
> markMLl.pgsql-general@telemetry.co.uk writes:
> > Where does PostgreSQL rank nulls when sorting a column of timestamps, is this
> > behaviour deterministic, and can I rely on it not changing in the future?
>
> Nulls sort high (in any datatype, not only timestamps).  It's possible
> that we'd offer an option to make them sort low in the future, but I
> can't imagine that we'd change the default behavior.

Isn't this behaviour implementation dependent, i.e. other database could
do it anyway they wanted?  Just thinking of portability issues one might
have if one were to rely on null sort order in an application.

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

Предыдущее
От: markMLl.pgsql-general@telemetry.co.uk
Дата:
Сообщение: Re: Nulls in timestamps
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Nulls in timestamps