diff options
| author | Andres Freund <andres@anarazel.de> | 2015-05-23 00:49:27 +0200 |
|---|---|---|
| committer | Andres Freund <andres@anarazel.de> | 2015-05-23 00:58:45 +0200 |
| commit | 631d7490074cdaef8026db57a5f2772b8730f600 (patch) | |
| tree | 56d0aee92bbe994583e095111f9ea23135c31d1c /doc/src/sgml/ref | |
| parent | 49ad32d5d99cb4a79bf648c0b7f9eca19b54cf1d (diff) | |
Remove the new UPSERT command tag and use INSERT instead.
Previously, INSERT with ON CONFLICT DO UPDATE specified used a new
command tag -- UPSERT. It was introduced out of concern that INSERT as
a command tag would be a misrepresentation for ON CONFLICT DO UPDATE, as
some affected rows may actually have been updated.
Alvaro Herrera noticed that the implementation of that new command tag
was incomplete; in subsequent discussion we concluded that having it
doesn't provide benefits that are in line with the compatibility breaks
it requires.
Catversion bump due to the removal of PlannedStmt->isUpsert.
Author: Peter Geoghegan
Discussion: 20150520215816.GI5885@postgresql.org
Diffstat (limited to 'doc/src/sgml/ref')
| -rw-r--r-- | doc/src/sgml/ref/insert.sgml | 21 |
1 files changed, 7 insertions, 14 deletions
diff --git a/doc/src/sgml/ref/insert.sgml b/doc/src/sgml/ref/insert.sgml index 3c3315eab3d..7cd4577f1ea 100644 --- a/doc/src/sgml/ref/insert.sgml +++ b/doc/src/sgml/ref/insert.sgml @@ -497,20 +497,13 @@ INSERT INTO <replaceable class="PARAMETER">table_name</replaceable> [ AS <replac <screen> INSERT <replaceable>oid</replaceable> <replaceable class="parameter">count</replaceable> </screen> - However, in the event of an <literal>ON CONFLICT DO UPDATE</> clause - (but <emphasis>not</emphasis> in the event of an <literal>ON - CONFLICT DO NOTHING</> clause), the command tag reports the number of - rows inserted or updated together, of the form -<screen> -UPSERT <replaceable>oid</replaceable> <replaceable class="parameter">count</replaceable> -</screen> - The <replaceable class="parameter">count</replaceable> is the number - of rows inserted. If <replaceable class="parameter">count</replaceable> - is exactly one, and the target table has OIDs, then - <replaceable class="parameter">oid</replaceable> is the - <acronym>OID</acronym> - assigned to the inserted row (but not if there is only a single - updated row). Otherwise <replaceable + The <replaceable class="parameter">count</replaceable> is the + number of rows inserted or updated. If <replaceable + class="parameter">count</replaceable> is exactly one, and the + target table has OIDs, then <replaceable + class="parameter">oid</replaceable> is the <acronym>OID</acronym> + assigned to the inserted row. The single row must have been + inserted rather than updated. Otherwise <replaceable class="parameter">oid</replaceable> is zero. </para> |