OK, I think I managed to figure out what it means by reading a little more
about the two CASE cases.
'CASE expr WHEN' compares the base expr with the WHEN expr, whereas
'CASE WHEN' compares the WHEN expr to true
So, the difference is more than just how many times 'x' is evaluated.
(Maybe the documentation needs some improvement.)
Thanks to all.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
