Skip site navigation (1) Skip section navigation (2)

Re: NULLs and sort order

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Rene Pijlman <rene(at)lab(dot)applinet(dot)nl>
Cc: pgsql-patches(at)postgresql(dot)org, pgsql-docs(at)postgresql(dot)org
Subject: Re: NULLs and sort order
Date: 2001-10-31 04:51:16
Message-ID: 200110310451.f9V4pGR15743@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-docspgsql-patches
Patch applied.  Thanks.

---------------------------------------------------------------------------


> 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(at)gmx(dot)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(at)gmx(dot)net   http://funkturm.homeip.net/~peter
> 
> Regards,
> Ren? Pijlman <rene(at)lab(dot)applinet(dot)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(at)candle(dot)pha(dot)pa(dot)us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

In response to

pgsql-docs by date

Next:From: Ho Pek LingDate: 2001-10-31 06:41:38
Subject:
Previous:From: Bruce MomjianDate: 2001-10-29 19:30:51
Subject: Re: SELECT syntax manual correction

pgsql-patches by date

Next:From: Bruce MomjianDate: 2001-10-31 04:55:17
Subject: Re: Traditional Chinese error messages for JDBC
Previous:From: Bruce MomjianDate: 2001-10-31 04:31:30
Subject: Re: update src/interfaces/libpq/zh_TW.po

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group