On 14 Nov 2012, at 3:17pm, kyan <alfasud...@gmail.com> wrote: > PS: Because of this the INSERT OR REPLACE statement cannot be > considered logically equivalent to MSSQL or ORACLE's MERGE statement > (http://en.wikipedia.org/wiki/Merge_%28SQL%29) which IMHO should be > added to SQLite at some point.
The two are sufficiently different that I would never confuse them. It's also worth knowing about UPDATE OR REPLACE which is similarly not MERGE, but has more MERGE-like behaviour. Though what it does I had to figure out myself since the documentation on the 'UPDATE' page doesn't describe it. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users