|
1 | | -<!-- $PostgreSQL: pgsql/doc/src/sgml/queries.sgml,v 1.52 2008/12/31 00:08:35 tgl Exp $ --> |
| 1 | +<!-- $PostgreSQL: pgsql/doc/src/sgml/queries.sgml,v 1.53 2009/02/07 20:11:16 momjian Exp $ --> |
2 | 2 |
|
3 | 3 | <chapter id="queries"> |
4 | 4 | <title>Queries</title> |
@@ -1402,8 +1402,9 @@ SELECT <replaceable>select_list</replaceable> |
1402 | 1402 |
|
1403 | 1403 | <para> |
1404 | 1404 | <literal>OFFSET</> says to skip that many rows before beginning to |
1405 | | - return rows. <literal>OFFSET 0</> is the same as |
1406 | | - omitting the <literal>OFFSET</> clause. If both <literal>OFFSET</> |
| 1405 | + return rows. <literal>OFFSET 0</> is the same as omitting the |
| 1406 | + <literal>OFFSET</> clause, and <literal>LIMIT NULL</> is the same |
| 1407 | + as omitting the <literal>LIMIT</> clause. If both <literal>OFFSET</> |
1407 | 1408 | and <literal>LIMIT</> appear, then <literal>OFFSET</> rows are |
1408 | 1409 | skipped before starting to count the <literal>LIMIT</> rows that |
1409 | 1410 | are returned. |
|