From: Bruce Momjian <pgman@candle.pha.pa.us>
To: Rene Pijlman <rene@lab.applinet.nl>
Cc: pgsql-patches@postgresql.org
Cc: pgsql-docs@postgresql.org
Subject: Re: NULLs and sort order
Date: Mon, 29 Oct 2001 14:27:27 -0500 (EST)
Message-ID: <200110291927.f9TJRRw12918@candle.pha.pa.us> (raw)
In-Reply-To: <v9uottkoaj7blja5g8ga1gr0k3008m06dt@4ax.com>
Your patch has been added to the PostgreSQL unapplied patches list at:
http://candle.pha.pa.us/cgi-bin/pgpatches
I will try to apply it within the next 48 hours.
---------------------------------------------------------------------------
> 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>
[ Attachment, skipping... ]
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
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: pgman@candle.pha.pa.us, rene@lab.applinet.nl, pgsql-patches@postgresql.org
Subject: Re: NULLs and sort order
In-Reply-To: <200110291927.f9TJRRw12918@candle.pha.pa.us>
* 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