Hello, How does one emulate a DML MERGE statement in SQLite [1]?
INSERT OR REPLACE sounds promising but the REPLACE documentation under the ON CONFLICT clause seems to imply that in the case of a constraint violation the existing row will be deleted entirely and then replaced by a brand new row instead of being merely updated [2]. Apologies if this is a FAQ, but my google-fu is eluding me on this one. Thanks in advance. Kind regards, -- PA. http://alt.textdrive.com/nanoki/ [1] http://en.wikipedia.org/wiki/Merge_(SQL) [2] http://www.mail-archive.com/sqlite-users@sqlite.org/msg24621.html _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
