diff options
Diffstat (limited to 'doc/src/sgml/ref/select.sgml')
| -rw-r--r-- | doc/src/sgml/ref/select.sgml | 7 |
1 files changed, 6 insertions, 1 deletions
diff --git a/doc/src/sgml/ref/select.sgml b/doc/src/sgml/ref/select.sgml index 96442a93084..7c7756808ea 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.122.2.1 2009/08/27 20:08:12 tgl Exp $ +$PostgreSQL: pgsql/doc/src/sgml/ref/select.sgml,v 1.122.2.2 2009/10/27 17:11:30 tgl Exp $ PostgreSQL documentation --> @@ -1126,6 +1126,11 @@ FOR SHARE [ OF <replaceable class="parameter">table_name</replaceable> [, ...] ] If <literal>FOR UPDATE</literal> or <literal>FOR SHARE</literal> is applied to a view or sub-query, it affects all tables used in the view or sub-query. + However, <literal>FOR UPDATE</literal>/<literal>FOR SHARE</literal> + do not apply to <literal>WITH</> queries referenced by the primary query. + If you want row locking to occur within a <literal>WITH</> query, specify + <literal>FOR UPDATE</literal> or <literal>FOR SHARE</literal> within the + <literal>WITH</> query. </para> <para> |