subject:"\[GENERAL\] Merge \- Insert Select"

Re: [GENERAL] Merge - Insert Select

2017-10-13 Thread Peter Geoghegan

On Fri, Oct 13, 2017 at 9:39 AM, Susan Hurst wrote: > Does postgres have a MERGE statement ala Oracle? No. > I have found examples online for INSERT...ON CONFLICT DO NOTHING, but all of > those examples use VALUES statements, which is not the scenario that I

[GENERAL] Merge - Insert Select

2017-10-13 Thread Susan Hurst

What is the best practice for doing an INSERT...SELECT statement for new values only. Existing values must be excluded from the insert. Does postgres have a MERGE statement ala Oracle? I have found examples online for INSERT...ON CONFLICT DO NOTHING, but all of those examples use VALUES