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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs pgsql-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

Browse pgsql-docs by date

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

Browse pgsql-patches by date

  From Date Subject
Next Message Peter Eisentraut 2001-09-09 16:05:43 Re: date_part patch
Previous Message Bruce Momjian 2001-09-09 14:22:41 Re: ECPG enhancements / fixes