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 &lt; and DESC is equivalent to USING &gt;. </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

 ·  · 

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