diff options
| -rw-r--r-- | doc/src/sgml/ref/merge.sgml | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/doc/src/sgml/ref/merge.sgml b/doc/src/sgml/ref/merge.sgml index f0745d01c7d..cbb5b38a3e3 100644 --- a/doc/src/sgml/ref/merge.sgml +++ b/doc/src/sgml/ref/merge.sgml @@ -23,27 +23,27 @@ MERGE INTO <replaceable class="parameter">target_table_name</replaceable> [ [ AS USING <replaceable class="parameter">data_source</replaceable> ON <replaceable class="parameter">join_condition</replaceable> <replaceable class="parameter">when_clause</replaceable> [...] -<phrase>where <replaceable class="parameter">data_source</replaceable> is</phrase> +<phrase>where <replaceable class="parameter">data_source</replaceable> is:</phrase> { <replaceable class="parameter">source_table_name</replaceable> | ( <replaceable class="parameter">source_query</replaceable> ) } [ [ AS ] <replaceable class="parameter">source_alias</replaceable> ] -<phrase>and <replaceable class="parameter">when_clause</replaceable> is</phrase> +<phrase>and <replaceable class="parameter">when_clause</replaceable> is:</phrase> { WHEN MATCHED [ AND <replaceable class="parameter">condition</replaceable> ] THEN { <replaceable class="parameter">merge_update</replaceable> | <replaceable class="parameter">merge_delete</replaceable> | DO NOTHING } | WHEN NOT MATCHED [ AND <replaceable class="parameter">condition</replaceable> ] THEN { <replaceable class="parameter">merge_insert</replaceable> | DO NOTHING } } -<phrase>and <replaceable class="parameter">merge_insert</replaceable> is</phrase> +<phrase>and <replaceable class="parameter">merge_insert</replaceable> is:</phrase> INSERT [( <replaceable class="parameter">column_name</replaceable> [, ...] )] [ OVERRIDING { SYSTEM | USER } VALUE ] { VALUES ( { <replaceable class="parameter">expression</replaceable> | DEFAULT } [, ...] ) | DEFAULT VALUES } -<phrase>and <replaceable class="parameter">merge_update</replaceable> is</phrase> +<phrase>and <replaceable class="parameter">merge_update</replaceable> is:</phrase> UPDATE SET { <replaceable class="parameter">column_name</replaceable> = { <replaceable class="parameter">expression</replaceable> | DEFAULT } | ( <replaceable class="parameter">column_name</replaceable> [, ...] ) = ( { <replaceable class="parameter">expression</replaceable> | DEFAULT } [, ...] ) } [, ...] -<phrase>and <replaceable class="parameter">merge_delete</replaceable> is</phrase> +<phrase>and <replaceable class="parameter">merge_delete</replaceable> is:</phrase> DELETE </synopsis> |