11<!--
2- $PostgreSQL: pgsql/doc/src/sgml/ref/update.sgml,v 1.35 2006/01/2205: 20:33 neilc Exp $
2+ $PostgreSQL: pgsql/doc/src/sgml/ref/update.sgml,v 1.36 2006/01/22 20:34:11 tgl Exp $
33PostgreSQL documentation
44-->
55
@@ -56,7 +56,7 @@ UPDATE [ ONLY ] <replaceable class="PARAMETER">table</replaceable> [ [ AS ] <rep
5656 You must have the <literal>UPDATE</literal> privilege on the table
5757 to update it, as well as the <literal>SELECT</literal>
5858 privilege to any table whose values are read in the
59- <replaceable class="parameter">expression </replaceable>s or
59+ <replaceable class="parameter">expressions </replaceable> or
6060 <replaceable class="parameter">condition</replaceable>.
6161 </para>
6262 </refsect1>
@@ -82,9 +82,7 @@ UPDATE [ ONLY ] <replaceable class="PARAMETER">table</replaceable> [ [ AS ] <rep
8282 provided, it completely hides the actual name of the table. For
8383 example, given <literal>UPDATE foo AS f</>, the remainder of the
8484 <command>UPDATE</command> statement must refer to this table as
85- <literal>f</> not <literal>foo</>. You cannot use the alias in
86- the <literal>SET</literal> clause. For example, <literal>SET
87- f.col = 1</> is invalid.
85+ <literal>f</> not <literal>foo</>.
8886 </para>
8987 </listitem>
9088 </varlistentry>
@@ -96,7 +94,9 @@ UPDATE [ ONLY ] <replaceable class="PARAMETER">table</replaceable> [ [ AS ] <rep
9694 The name of a column in <replaceable
9795 class="PARAMETER">table</replaceable>.
9896 The column name can be qualified with a subfield name or array
99- subscript, if needed.
97+ subscript, if needed. Do not include the table's name in the
98+ specification of a target column — for example,
99+ <literal>UPDATE tab SET tab.col = 1</> is invalid.
100100 </para>
101101 </listitem>
102102 </varlistentry>