2 ms·
i'd like to see an explanation of why this syntax was chosen instead of ANSI MERGE (http://en.wikipedia.org/wiki/Merge_%28SQL%29 http://en.wikipedia.org/wiki/Me
by baq 12y ago
i'd like to see an explanation of why this syntax was chosen instead of ANSI MERGE (http://en.wikipedia.org/wiki/Merge_%28SQL%29 http://en.wikipedia.org/wiki/Merge_%28SQL%29).
- benhoyt 12y agoLooks like there's a thorough discussion of the pros and cons on the PostgreSQL wiki here: https://wiki.postgresql.org/wiki/UPSERT#SQL_MERGE_syntax https://wiki.postgresql.org/wiki/UPSERT#SQL_MERGE_syntax
- swsieber 12y agoThe semantics are slightly different - the Postgres command doesn't do the exact same thing. So rather have two identically named commands that do slightly different things, they picked a different syntax so it would be clear they aren't the same.
- ashmud 12y agoSome of the reasons were discussed previously: https://news.ycombinator.com/item?id=9509870 https://news.ycombinator.com/item?id=9509870