Jaime Casanova wrote: > On Wed, Feb 4, 2009 at 12:33 PM, Robert Haas <robertmh...@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 <br...@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.
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers