diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2016-07-08 12:46:04 -0400 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2016-07-08 12:46:12 -0400 |
| commit | fead79407a601845b97ed74b8de9e8c865f5eba0 (patch) | |
| tree | 3776899d7ab43b64349d4a27ee43020b31efe442 /doc/src | |
| parent | 31ce32ade428dd3ea11ea468f8bdd6492b991ed1 (diff) | |
| download | postgresql-fead79407a601845b97ed74b8de9e8c865f5eba0.tar.gz postgresql-fead79407a601845b97ed74b8de9e8c865f5eba0.zip | |
Docs: improve examples about not repeating table name in UPDATE ... SET.
Alexander Law
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/insert.sgml | 4 | ||||
| -rw-r--r-- | doc/src/sgml/ref/update.sgml | 2 |
2 files changed, 3 insertions, 3 deletions
diff --git a/doc/src/sgml/ref/insert.sgml b/doc/src/sgml/ref/insert.sgml index e710cf4091b..0406a097f55 100644 --- a/doc/src/sgml/ref/insert.sgml +++ b/doc/src/sgml/ref/insert.sgml @@ -194,8 +194,8 @@ INSERT INTO <replaceable class="PARAMETER">table_name</replaceable> [ AS <replac column leaves the other fields null.) When referencing a column with <literal>ON CONFLICT DO UPDATE</>, do not include the table's name in the specification of a target column. For - example, <literal>INSERT ... ON CONFLICT DO UPDATE tab SET - table_name.col = 1</> is invalid (this follows the general + example, <literal>INSERT INTO table_name ... ON CONFLICT DO UPDATE + SET table_name.col = 1</> is invalid (this follows the general behavior for <command>UPDATE</>). </para> </listitem> diff --git a/doc/src/sgml/ref/update.sgml b/doc/src/sgml/ref/update.sgml index 35b0699f086..c50434f85f9 100644 --- a/doc/src/sgml/ref/update.sgml +++ b/doc/src/sgml/ref/update.sgml @@ -123,7 +123,7 @@ UPDATE [ ONLY ] <replaceable class="PARAMETER">table_name</replaceable> [ * ] [ The column name can be qualified with a subfield name or array subscript, if needed. Do not include the table's name in the specification of a target column — for example, - <literal>UPDATE tab SET tab.col = 1</> is invalid. + <literal>UPDATE table_name SET table_name.col = 1</> is invalid. </para> </listitem> </varlistentry> |