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@gmx.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@gmx.net http://funkturm.homeip.net/~peter
Regards,
René Pijlman <rene@lab.applinet.nl>