On 25 Nov 2012, at 4:22pm, Imanuel <my_mailings_addr...@gmx.de> wrote:
> I'm not saying your statement is inefficient, I'm saying it's wrong > because it produces unwanted results. > > If the fields a,b,c ('12','34','56') should be updated to > ('1','2345','6') your statement would fail instead of doing the expected > update. You're absolutely right. I should be worried about false negatives. It's the false positives I don't have to worry about. Thanks for the correction. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users