Comment by MarkusWinand
3 hours ago
INSERT ... ON CONFLICT has fewer surprises in context of concurrency: https://modern-sql.com/caniuse/merge#illogical-errors
Besides portability, there is IMHO nothing against INSERT ... ON CONFLICT if it does what you need.
No comments yet
Contribute on Hacker News ↗