diff options
| author | Bruce Momjian <bruce@momjian.us> | 2005-04-22 15:53:27 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2005-04-22 15:53:27 +0000 |
| commit | 8e4b89ccf2884d9646eeaa4fe309d371726ebe24 (patch) | |
| tree | dfd39409dd106cb643f84c8556112506799527a5 | |
| parent | ddae2b6801b23765a0e73c0ddbb4f97f65d5e6f2 (diff) | |
Backpatch of LIMIT / FOR UPDATE behavior, but keep pre-7.3 mention in 8.0.X.
| -rw-r--r-- | doc/src/sgml/ref/select.sgml | 12 |
1 files changed, 11 insertions, 1 deletions
diff --git a/doc/src/sgml/ref/select.sgml b/doc/src/sgml/ref/select.sgml index 5046326e54c..c528010723b 100644 --- a/doc/src/sgml/ref/select.sgml +++ b/doc/src/sgml/ref/select.sgml @@ -1,5 +1,5 @@ <!-- -$PostgreSQL: pgsql/doc/src/sgml/ref/select.sgml,v 1.80.4.1 2005/01/22 23:23:53 momjian Exp $ +$PostgreSQL: pgsql/doc/src/sgml/ref/select.sgml,v 1.80.4.2 2005/04/22 15:53:27 momjian Exp $ PostgreSQL documentation --> @@ -819,6 +819,16 @@ FOR UPDATE [ OF <replaceable class="parameter">table_name</replaceable> [, ...] </para> <para> + It is possible for a <command>SELECT</> command using both + <literal>LIMIT</literal> and <literal>FOR UPDATE</literal> + clauses to return fewer rows than specified by <literal>LIMIT</literal>. + This is because <literal>LIMIT</> selects a number of rows, + but might then block requesting a <literal>FOR UPDATE</literal> lock. + Once the <literal>SELECT</> unblocks, the query qualification might not + be met and the row not be returned by <literal>SELECT</>. + </para> + + <para> <literal>FOR UPDATE</literal> may appear before <literal>LIMIT</literal> for compatibility with <productname>PostgreSQL</productname> versions before 7.3. It |