> No, because INSERT OR REPLACE can delete several rows and insert one > row instead of that. This kind of operation cannot be covered by UPDATE > in any way.
I hadn't thought of that.. I suppose if two independent unique indexes had a constraint violation by the same record, it would delete two records and replace with one. I've never had to worry about that. For my purposes, I'd rather it UPDATE if only one record is affected. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users