Postgres Pro
Downloads
Home   >   mailing lists

Re: Output clause for Upsert aka INSERT...ON CONFLICT - Mailing list pgsql-hackers

From David G. Johnston
Subject Re: Output clause for Upsert aka INSERT...ON CONFLICT
Date
Msg-id CAKFQuwaRnESEH=ZmqbfwzXT+twStJ-aVYjFQC9TV-=h5KeY6Cg@mail.gmail.com
Whole thread Raw
In response to Re: Output clause for Upsert aka INSERT...ON CONFLICT  (Anand Sowmithiran <anandsowmi2@gmail.com>)
List pgsql-hackers
Tree view
On Thursday, January 27, 2022, Anand Sowmithiran <anandsowmi2@gmail.com> wrote:
However, the MS SQL server MERGE command also does 'delete' using the 'when not matched' clause, is there an equivalent ?

PostgreSQL does not have a merge command feature.  Just the subset of behavior that is INSERT…on conflict

David J.

pgsql-hackers by date:

Previous
From: Ajin Cherian
Date:
Subject: Re: logical replication empty transactions
Next
From: Peter Eisentraut
Date:
Subject: Re: psql - add SHOW_ALL_RESULTS option