Jaime Casanova wrote:
> On Wed, Feb 4, 2009 at 12:33 PM, Robert Haas <robertmhaas@gmail.com> wrote:
> >
> > Still, the queries-limit.html page includes this statement: "OFFSET 0
> > is the same as omitting the OFFSET clause." I don't see that there
> > would be anything bad or confusing about changing it to read this way:
> > "OFFSET 0 is the same as omitting the OFFSET clause, and LIMIT NULL is
> > the same as omitting the LIMIT clause." In fact, it seems nicely
> > symmetric.
> >
>
> good point...
>
> can we just apply this one and let this discussion off?
> or maybe remove the OFFSET part and point to the SQL COMMAND
> references page? (doesn't seem appropiate to me to reject the LIMIT
> comment and let the other one in there while they are almost the same)
Patch attached and applied.
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
Index: doc/src/sgml/queries.sgml
===================================================================
RCS file: /cvsroot/pgsql/doc/src/sgml/queries.sgml,v
retrieving revision 1.52
diff -c -c -r1.52 queries.sgml
*** doc/src/sgml/queries.sgml 31 Dec 2008 00:08:35 -0000 1.52
--- doc/src/sgml/queries.sgml 7 Feb 2009 20:09:53 -0000
***************
*** 1402,1409 ****
<para>
<literal>OFFSET</> says to skip that many rows before beginning to
! return rows. <literal>OFFSET 0</> is the same as
! omitting the <literal>OFFSET</> clause. If both <literal>OFFSET</>
and <literal>LIMIT</> appear, then <literal>OFFSET</> rows are
skipped before starting to count the <literal>LIMIT</> rows that
are returned.
--- 1402,1410 ----
<para>
<literal>OFFSET</> says to skip that many rows before beginning to
! return rows. <literal>OFFSET 0</> is the same as omitting the
! <literal>OFFSET</> clause, and <literal>LIMIT NULL</> is the same
! as omitting the <literal>LIMIT</> clause. If both <literal>OFFSET</>
and <literal>LIMIT</> appear, then <literal>OFFSET</> rows are
skipped before starting to count the <literal>LIMIT</> rows that
are returned.