On 25 Nov 2012, at 4:22pm, Imanuel <[email protected]> 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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
