pg.ddx.io  pgsql-docs@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Rene Pijlman <rene@lab.applinet.nl>
To: pgsql-docs@postgresql.org
Subject: NULLs and sort order
Date: Sun, 09 Sep 2001 16:58:18 +0200
Message-ID: <7b0npts2v4csnqttdoviurtnsbvafape0v@4ax.com> (raw)

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>



view thread (5+ messages)  latest in thread

Message-ID: <7b0npts2v4csnqttdoviurtnsbvafape0v@4ax.com>
Permalink:  ../7b0npts2v4csnqttdoviurtnsbvafape0v@4ax.com/
Also on:    postgresql.org/message-id/7b0npts2v4csnqttdoviurtnsbvafape0v@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 using the --to and --cc options:
  reply via email

  To: pgsql-docs@postgresql.org
  Cc: rene@lab.applinet.nl
  Subject: Re: NULLs and sort order
  In-Reply-To: <7b0npts2v4csnqttdoviurtnsbvafape0v@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