diff options
| author | Bruce Momjian <bruce@momjian.us> | 2009-02-07 20:11:16 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2009-02-07 20:11:16 +0000 |
| commit | 053835d334a6c533e3304e0171c078bc04f9514c (patch) | |
| tree | 106647fa2f52e0bcb1666fb085d539673dd2692f | |
| parent | 97072ad80c406e58b04d15204941889bf29d9c83 (diff) | |
| download | postgresql-053835d334a6c533e3304e0171c078bc04f9514c.tar.gz postgresql-053835d334a6c533e3304e0171c078bc04f9514c.zip | |
Document that LIMIT NULL is the same as no LIMIT clause.
| -rw-r--r-- | doc/src/sgml/queries.sgml | 7 |
1 files changed, 4 insertions, 3 deletions
diff --git a/doc/src/sgml/queries.sgml b/doc/src/sgml/queries.sgml index 7aaeea993cf..71a33fff662 100644 --- a/doc/src/sgml/queries.sgml +++ b/doc/src/sgml/queries.sgml @@ -1,4 +1,4 @@ -<!-- $PostgreSQL: pgsql/doc/src/sgml/queries.sgml,v 1.52 2008/12/31 00:08:35 tgl Exp $ --> +<!-- $PostgreSQL: pgsql/doc/src/sgml/queries.sgml,v 1.53 2009/02/07 20:11:16 momjian Exp $ --> <chapter id="queries"> <title>Queries</title> @@ -1402,8 +1402,9 @@ SELECT <replaceable>select_list</replaceable> <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</> + 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. |