Hacker News new | ask | show | jobs
by trollied 1347 days ago
It kind of did support it before. You could do an INSERT … ON CONFLICT ( keys here) DO UPDATE update query here
2 comments

This only works if you reference a combination of columns that has been declared as unique which is not always something you want or can do.
Merge has a few more capabilities beyond that, but I think that's where you'd want to use it the most.