Re: Output clause for Upsert aka INSERT...ON CONFLICT

there an equivalent ? thanks, Anand. On Thu, Jan 27, 2022 at 11:29 AM Justin Pryzby wrote: > On Thu, Jan 27, 2022 at 10:24:14AM +0530, Anand Sowmithiran wrote: > > The INSERT...ON CONFLICT is used for doing upserts in one of our app. > > Our app works with both MS SQL and

Output clause for Upsert aka INSERT...ON CONFLICT

The INSERT...ON CONFLICT is used for doing upserts in one of our app. Our app works with both MS SQL and Postgresql, based on customer needs. Unlike the MS SQL MERGE command's OUTPUT clause that gives the $action