Y
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
LunaSea
1347 days ago
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.
link
cogman10
1347 days ago
Merge has a few more capabilities beyond that, but I think that's where you'd want to use it the most.
link