Re:SQLite: Small, Fast, Reliable – Choose any three
by ianamartin on Tuesday July 15, 2014 @12:56AM
(#8034860)
Postgres still doesn't have upsert either. Neither does sql server or Oracle. I hardly see that as a knock against SQLite. All of the above have various levels of hackey workaround so for this though.
[ Parent
| on HN ]
Re:SQLite: Small, Fast, Reliable – Choose any three
by aratob on Tuesday July 15, 2014 @02:14AM
(#8035050)
Oracle actually has upsert functionality. It is called Merge and has been available for quite a long time:
http://docs.oracle.com/cd/B28359_01/server.111/b28286/statem...