Re: NULLs and sort order - Mailing list pgsql-jdbc

From Peter Eisentraut
Subject Re: NULLs and sort order
Date
Msg-id Pine.LNX.4.30.0109091524410.680-100000@peter.localdomain
Whole thread Raw
In response to NULLs and sort order  (Rene Pijlman <rene@lab.applinet.nl>)
Responses Re: NULLs and sort order  (Rene Pijlman <rene@lab.applinet.nl>)
Re: [HACKERS] NULLs and sort order  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-jdbc
Rene Pijlman writes:

> Currently the JDBC driver says:
> - Backend >= 7.2 sorts nulls higher than any other value in a
> domain. In other words: ascending means nulls at the end,
> descending means nulls at the start.
> - Backend < 7.2 puts nulls at the end regardless of sort order.

That is correct.

> Would it be useful to add this information to the documentation,
> e.g. the documentation of ORDER BY in SELECT?

Most likely.

--
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter


pgsql-jdbc by date:

Previous
From: Rene Pijlman
Date:
Subject: Re: [HACKERS] JDBC pg_description update needed for CVS tip
Next
From: Rene Pijlman
Date:
Subject: Re: NULLs and sort order