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>
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 |
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 |