pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feed From: Rene Pijlman <rene@lab.applinet.nl>
To: pgsql-patches@postgresql.org
Cc: pgsql-docs@postgresql.org
Subject: Re: NULLs and sort order
Date: Sun, 28 Oct 2001 22:39:23 +0100
Message-ID: <v9uottkoaj7blja5g8ga1gr0k3008m06dt@4ax.com> (raw )
In-Reply-To: <7b0npts2v4csnqttdoviurtnsbvafape0v@4ax.com >
References: <7b0npts2v4csnqttdoviurtnsbvafape0v@4ax.com >
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@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>
Attachments:
patch.diff (text/plain, 806B) download
Index: doc/src/sgml/ref/select.sgml
===================================================================
RCS file: /projects/cvsroot/pgsql/doc/src/sgml/ref/select.sgml,v
retrieving revision 1.49
diff -c -r1.49 select.sgml
*** doc/src/sgml/ref/select.sgml 2001/10/23 16:42:36 1.49
--- doc/src/sgml/ref/select.sgml 2001/10/28 21:37:26
***************
*** 601,606 ****
--- 601,613 ----
specific ordering operator name may be specified. ASC is equivalent
to USING < and DESC is equivalent to USING >.
</para>
+
+ <para>
+ The null value sorts higher than any other value in a domain. In other
+ words, with ascending sort order nulls sort at the end and with
+ descending sort order nulls sort at the start.
+ </para>
+
</refsect2>
<refsect2 id="SQL-UNION">
view thread (5+ messages) latest in thread
Message-ID: <v9uottkoaj7blja5g8ga1gr0k3008m06dt@4ax.com>
Permalink: ../v9uottkoaj7blja5g8ga1gr0k3008m06dt@4ax.com/
Also on: postgresql.org/message-id/v9uottkoaj7blja5g8ga1gr0k3008m06dt@4ax.com
copy link · copy postgr.es · copy git am
reply Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-docs@postgresql.org
Cc: rene@lab.applinet.nl, pgsql-patches@postgresql.org
Subject: Re: NULLs and sort order
In-Reply-To: <v9uottkoaj7blja5g8ga1gr0k3008m06dt@4ax.com>
References: <7b0npts2v4csnqttdoviurtnsbvafape0v@4ax.com> <v9uottkoaj7blja5g8ga1gr0k3008m06dt@4ax.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox