|
1 | 1 | <!-- |
2 | | -$PostgreSQL: pgsql/doc/src/sgml/ref/select.sgml,v 1.130 2010/04/03 07:23:02 petere Exp $ |
| 2 | +$PostgreSQL: pgsql/doc/src/sgml/ref/select.sgml,v 1.131 2010/06/15 20:04:53 momjian Exp $ |
3 | 3 | PostgreSQL documentation |
4 | 4 | --> |
5 | 5 |
|
@@ -1200,8 +1200,9 @@ FOR SHARE [ OF <replaceable class="parameter">table_name</replaceable> [, ...] ] |
1200 | 1200 | case of a join query, the rows locked are those that contribute to |
1201 | 1201 | returned join rows. In addition, rows that satisfied the query |
1202 | 1202 | conditions as of the query snapshot will be locked, although they |
1203 | | - will not be returned if they have since been updated to not satisfy |
1204 | | - the query conditions. If a <literal>LIMIT</> is used, locking stops |
| 1203 | + will not be returned if they were updated after the snapshot |
| 1204 | + and no longer satisfy the query conditions. If a |
| 1205 | + <literal>LIMIT</> is used, locking stops |
1205 | 1206 | once enough rows have been returned to satisfy the limit (but note that |
1206 | 1207 | rows skipped over by <literal>OFFSET</> will get locked). Similarly, |
1207 | 1208 | if <literal>FOR UPDATE</literal> or <literal>FOR SHARE</literal> |
|