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
>>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
René Pijlman <rene(at)lab(dot)applinet(dot)nl>
Description: text/plain (807 bytes)
In response to
pgsql-docs by date
|Next:||From: Neil Zanella||Date: 2001-10-29 03:00:08|
|Subject: SELECT syntax manual correction|
|Previous:||From: Peter Eisentraut||Date: 2001-10-20 11:45:38|
|Subject: Re: Suggestion ...|
pgsql-patches by date
|Next:||From: Joe Conway||Date: 2001-10-29 06:55:01|
|Previous:||From: Bill Studenmund||Date: 2001-10-28 09:35:34|
|Subject: Patch to add CREATE OPERATOR CLASS|