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: v9uottkoaj7blja5g8ga1gr0k3008m06dt@4ax.com (view raw or flat)
Thread:
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   http://funkturm.homeip.net/~peter

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

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

In response to

Responses

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-2014 The PostgreSQL Global Development Group