On Mar 7, 2013, at 7:53 PM, Ryan Johnson <ryan.john...@cs.utoronto.ca> wrote:

> Meanwhile, though, I'd be delighted if column affinity, cast(), implicit 
> conversions performed by arithmetic operations, check(), and triggers all 
> behaved the same way, with the current behavior of column affinity probably 
> the least surprising/troublesome. Right now those five operations have four 
> different behaviors to keep track of.

select 1 + '1abc';
> 2

select '1abc' + '1abc';
> 2

… okidoki...
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to