3 ms·
Who decided the syntax? Why not use MERGE ... INTO ... USING ... ON ... WHEN like Oracle and MSSQL and apparently ANSI SQL [1]? I'm not aware of ON CONFLICT bei
by taspeotis 12y ago
Who decided the syntax? Why not use MERGE ... INTO ... USING ... ON ... WHEN like Oracle and MSSQL and apparently ANSI SQL [1]? I'm not aware of ON CONFLICT being standard.
[1] http://en.wikipedia.org/wiki/Merge_(SQL) http://en.wikipedia.org/wiki/Merge_(SQL)
- veddan 12y agoThere's some extended discussion of the issue on the wiki[1]. A future full MERGE implementation might have slightly different semantics or performance characteristics than ON CONFLICT (which might also differ from other DBMS). [1] https://wiki.postgresql.org/wiki/UPSERT#SQL_MERGE_syntax https://wiki.postgresql.org/wiki/UPSERT#SQL_MERGE_syntax