[EMAIL PROTECTED] wrote:
This gives a different answer because the EXCEPT operator makes the rows of the result set unique. So the result set will be: 1 2 111 where as formerly it was 1 1 2 2 111 111
Thank you for the clarification. That is not the behavior I would have expected. In my data everything is distinct anyway, but for others the difference would be important.
BTW, http://sqlite.org/lang_select.html says "EXCEPT takes the result of left SELECT after removing the results of the right SELECT." Some further explanation there might help keep others from making the same mistake I did.
Another question: Is it correct that virtual tables can be created using Perl but not Tcl? I don't have a current need (with the possible exception of FTS1/2, which are already accessible from Tcl), but the situation seemed curious. Wondering whether there was an undocumented capability (or one I just missed in the docs).
Thanks again for a great product with incredible support. Gerry ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
