pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedNULLs and sort order
5+ messages / 3 participants
[nested] [flat]
* NULLs and sort order
@ 2001-09-09 14:58 Rene Pijlman <rene@lab.applinet.nl>
0 siblings, 2 replies; 5+ messages in thread
From: Rene Pijlman @ 2001-09-09 14:58 UTC (permalink / raw)
To: pgsql-docs
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@gmx.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@gmx.net http://funkturm.homeip.net/~peter
Regards,
René Pijlman <rene@lab.applinet.nl>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: NULLs and sort order
@ 2001-09-11 15:13 Thomas Lockhart <lockhart@fourpalms.org>
parent: Rene Pijlman <rene@lab.applinet.nl>
1 sibling, 0 replies; 5+ messages in thread
From: Thomas Lockhart @ 2001-09-11 15:13 UTC (permalink / raw)
To: Rene Pijlman <rene@lab.applinet.nl>; +Cc: pgsql-docs
...
> Or am I expected to submit a patch on the Docbook sources?
...
"Expected"? No. But it sure would be preferable since you would get it
the way you think it should be, and others could spend time on other
things.
An alternative, if you are not comfortable diving into sgml markup, is
to find the place in the sgml where the changes should be, but just put
them in without markup. Someone else like Peter or myself would be happy
to fix up the markup.
- Thomas
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: NULLs and sort order
@ 2001-10-28 21:39 Rene Pijlman <rene@lab.applinet.nl>
parent: Rene Pijlman <rene@lab.applinet.nl>
1 sibling, 2 replies; 5+ messages in thread
From: Rene Pijlman @ 2001-10-28 21:39 UTC (permalink / raw)
To: pgsql-patches@postgresql.org; +Cc: pgsql-docs
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@gmx.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@gmx.net http://funkturm.homeip.net/~peter
Regards,
René Pijlman <rene@lab.applinet.nl>
Attachments:
patch.diff (text/plain, 806B) download
Index: doc/src/sgml/ref/select.sgml
===================================================================
RCS file: /projects/cvsroot/pgsql/doc/src/sgml/ref/select.sgml,v
retrieving revision 1.49
diff -c -r1.49 select.sgml
*** doc/src/sgml/ref/select.sgml 2001/10/23 16:42:36 1.49
--- doc/src/sgml/ref/select.sgml 2001/10/28 21:37:26
***************
*** 601,606 ****
--- 601,613 ----
specific ordering operator name may be specified. ASC is equivalent
to USING < and DESC is equivalent to USING >.
</para>
+
+ <para>
+ The null value sorts higher than any other value in a domain. In other
+ words, with ascending sort order nulls sort at the end and with
+ descending sort order nulls sort at the start.
+ </para>
+
</refsect2>
<refsect2 id="SQL-UNION">
* Re: NULLs and sort order
@ 2001-10-29 19:27 Bruce Momjian <pgman@candle.pha.pa.us>
parent: Rene Pijlman <rene@lab.applinet.nl>
1 sibling, 0 replies; 5+ messages in thread
From: Bruce Momjian @ 2001-10-29 19:27 UTC (permalink / raw)
To: Rene Pijlman <rene@lab.applinet.nl>; +Cc: pgsql-patches@postgresql.org; pgsql-docs
Your patch has been added to the PostgreSQL unapplied patches list at:
http://candle.pha.pa.us/cgi-bin/pgpatches
I will try to apply it within the next 48 hours.
---------------------------------------------------------------------------
> 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@gmx.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@gmx.net http://funkturm.homeip.net/~peter
>
> Regards,
> Ren? Pijlman <rene@lab.applinet.nl>
[ Attachment, skipping... ]
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: NULLs and sort order
@ 2001-10-31 04:51 Bruce Momjian <pgman@candle.pha.pa.us>
parent: Rene Pijlman <rene@lab.applinet.nl>
1 sibling, 0 replies; 5+ messages in thread
From: Bruce Momjian @ 2001-10-31 04:51 UTC (permalink / raw)
To: Rene Pijlman <rene@lab.applinet.nl>; +Cc: pgsql-patches@postgresql.org; pgsql-docs
Patch applied. Thanks.
---------------------------------------------------------------------------
> 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@gmx.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@gmx.net http://funkturm.homeip.net/~peter
>
> Regards,
> Ren? Pijlman <rene@lab.applinet.nl>
[ Attachment, skipping... ]
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2001-10-31 04:51 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-09-09 14:58 NULLs and sort order Rene Pijlman <rene@lab.applinet.nl>
2001-09-11 15:13 ` Thomas Lockhart <lockhart@fourpalms.org>
2001-10-28 21:39 ` Rene Pijlman <rene@lab.applinet.nl>
2001-10-29 19:27 ` Bruce Momjian <pgman@candle.pha.pa.us>
2001-10-31 04:51 ` Bruce Momjian <pgman@candle.pha.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox