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

Re: NULLs and sort order

From: Rene Pijlman <rene(at)lab(dot)applinet(dot)nl>
To: pgsql-patches(at)postgresql(dot)org
Cc: pgsql-docs(at)postgresql(dot)org
Subject: Re: NULLs and sort order
Date: 2001-10-28 21:39:23
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-docspgsql-patches
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

René Pijlman <rene(at)lab(dot)applinet(dot)nl>

Attachment: patch.diff
Description: text/plain (807 bytes)

In response to


pgsql-docs by date

Next:From: Neil ZanellaDate: 2001-10-29 03:00:08
Subject: SELECT syntax manual correction
Previous:From: Peter EisentrautDate: 2001-10-20 11:45:38
Subject: Re: Suggestion ...

pgsql-patches by date

Next:From: Joe ConwayDate: 2001-10-29 06:55:01
Subject: contrib/fuzzystrmatch
Previous:From: Bill StudenmundDate: 2001-10-28 09:35:34
Subject: Patch to add CREATE OPERATOR CLASS

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