Attached is a small patch for the Reference Manual which adds
information about nulls and sort order.
This is based on information obtained from Peter Eisentraut and
Tom Lane on pgsql-hackers.
Please check my English and Docbook markup, as both are a second
language to me.
On Sun, 09 Sep 2001 16:58:18 +0200, I wrote:
>I'm forwarding this information from Peter Eisentraut on
>pgsql-hackers about NULLs and sort order. I couldn't find this
>in the documentation.
>
>I guess it should be in "ORDER BY Clause" of "SELECT" in the
>Reference Manual, and in the 7.2 release notes.
>
>Can someone add this to the documentation?
>
>Or am I expected to submit a patch on the Docbook sources?
>
>On Sun, 9 Sep 2001 15:25:17 +0200 (CEST), Peter Eisentraut
><peter_e(at)gmx(dot)net> wrote:
>>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.
>>
>>--
>>Peter Eisentraut peter_e(at)gmx(dot)net http://funkturm.homeip.net/~peter
Regards,
René Pijlman <rene(at)lab(dot)applinet(dot)nl>