A while I ago I covered the upsert feature PostgreSQL introduced with version 9.5. Back then I showed you how to make use of upsert with one field - the primary key - as conflict target. In a recent attempt to modify the upsert logic to take 2 fields into account I tried to add the additional field to the conflict target:
PostgreSQL Upsert with multiple fields
This blog post was published more than one year ago and might be outdated!
· 2 min read