On Feb 19, 2012, at 6:16 PM, Roger Andersson wrote: > insert or replace
One thing to keep in mind when using "insert or replace" is that this will create an entirely new record each and every single time. Which means the rowid is always going to change. Which makes it a very poor candidate as a surrogate key. Which is a bit of a bummer. In other words, "insert or replace" is not a good substitute for a merge statement, _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users