diff options
| author | Bruce Momjian <bruce@momjian.us> | 2023-12-07 19:43:04 -0500 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2023-12-07 19:43:04 -0500 |
| commit | 5134e9d295f335b4ee9f8846f934e5593f65e881 (patch) | |
| tree | 78bfdd84283f72d4ab33950a0e1ece1133c1bc22 | |
| parent | 651030a3d7b44e0f448f860f6cccc1b0eff26ac6 (diff) | |
| download | postgresql-5134e9d295f335b4ee9f8846f934e5593f65e881.tar.gz postgresql-5134e9d295f335b4ee9f8846f934e5593f65e881.zip | |
doc: FOR UPDATE / KEY / SHARE / KEY SHARE takes an table alias
Previously only a table name was documented for this SELECT clause.
Reported-by: robert <lists@humanleg.org.uk>
Discussion: https://postgr.es/m/152483686904.19805.3369061025704720797@wrigleys.postgresql.org
Backpatch-through: master
| -rw-r--r-- | doc/src/sgml/ref/select.sgml | 11 |
1 files changed, 7 insertions, 4 deletions
diff --git a/doc/src/sgml/ref/select.sgml b/doc/src/sgml/ref/select.sgml index 227ba1993bb..9917df7839b 100644 --- a/doc/src/sgml/ref/select.sgml +++ b/doc/src/sgml/ref/select.sgml @@ -45,7 +45,7 @@ SELECT [ ALL | DISTINCT [ ON ( <replaceable class="parameter">expression</replac [ LIMIT { <replaceable class="parameter">count</replaceable> | ALL } ] [ OFFSET <replaceable class="parameter">start</replaceable> [ ROW | ROWS ] ] [ FETCH { FIRST | NEXT } [ <replaceable class="parameter">count</replaceable> ] { ROW | ROWS } { ONLY | WITH TIES } ] - [ FOR { UPDATE | NO KEY UPDATE | SHARE | KEY SHARE } [ OF <replaceable class="parameter">table_name</replaceable> [, ...] ] [ NOWAIT | SKIP LOCKED ] [...] ] + [ FOR { UPDATE | NO KEY UPDATE | SHARE | KEY SHARE } [ OF <replaceable class="parameter">from_reference</replaceable> [, ...] ] [ NOWAIT | SKIP LOCKED ] [...] ] <phrase>where <replaceable class="parameter">from_item</replaceable> can be one of:</phrase> @@ -1577,7 +1577,7 @@ FETCH { FIRST | NEXT } [ <replaceable class="parameter">count</replaceable> ] { The locking clause has the general form <synopsis> -FOR <replaceable>lock_strength</replaceable> [ OF <replaceable class="parameter">table_name</replaceable> [, ...] ] [ NOWAIT | SKIP LOCKED ] +FOR <replaceable>lock_strength</replaceable> [ OF <replaceable class="parameter">from_reference</replaceable> [, ...] ] [ NOWAIT | SKIP LOCKED ] </synopsis> where <replaceable>lock_strength</replaceable> can be one of @@ -1591,8 +1591,11 @@ KEY SHARE </para> <para> - For more information on each row-level lock mode, refer to - <xref linkend="locking-rows"/>. + <replaceable class="parameter">from_reference</replaceable> must be a + table <replaceable class="parameter">alias</replaceable> or non-hidden + <replaceable class="parameter">table_name</replaceable> referenced + in the <literal>FROM</literal> clause. For more information on each + row-level lock mode, refer to <xref linkend="locking-rows"/>. </para> <para> |