Re: Nulls in timestamps - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Nulls in timestamps
Date
Msg-id 1121278558.8208.257.camel@state.g2switchworks.com
Whole thread Raw
In response to Re: Nulls in timestamps  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Nulls in timestamps
List 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 by date:

Previous
From: markMLl.pgsql-general@telemetry.co.uk
Date:
Subject: Re: Nulls in timestamps
Next
From: Tom Lane
Date:
Subject: Re: Nulls in timestamps