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

NULLs and sort order

From: Rene Pijlman <rene(at)lab(dot)applinet(dot)nl>
To: pgsql-docs(at)postgresql(dot)org
Subject: NULLs and sort order
Date: 2001-09-09 14:58:18
Message-ID: 7b0npts2v4csnqttdoviurtnsbvafape0v@4ax.com (view raw or flat)
Thread:
Lists: pgsql-docspgsql-patches
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>

Responses

pgsql-docs by date

Next:From: Alexander ZaitsevDate: 2001-09-10 14:29:21
Subject: Two digits year formatting
Previous:From: Justin CliftDate: 2001-09-08 07:26:32
Subject: Re: [GENERAL] SQL Server to PostgreSQL HOWTO

pgsql-patches by date

Next:From: Peter EisentrautDate: 2001-09-09 16:05:43
Subject: Re: date_part patch
Previous:From: Bruce MomjianDate: 2001-09-09 14:22:41
Subject: Re: ECPG enhancements / fixes

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