On Wed, 2005-07-13 at 12:41, Tom Lane wrote:
> markMLl.pgsql-general@xxxxxxxxxxxxxxx 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.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
