Обсуждение: Re: [DOCS] NULLs and sort order
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>
Вложения
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
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