On 7 Mar 2013, at 1:36pm, "Michael Black" <mdblac...@yahoo.com> wrote:
> New:
> select cast('2' as integer);
> 2
> select cast('2a' as integer);
> 0
Sorry, but that's very bad. There is no way that the string '2a' could
represent 0. I agree that interpreting '2a' as the integer 2 may be considered
wrong, but I think you're solving the problem the wrong way.
If you want to indicate a problem, I would like to suggest that you either
return NULL or have sqlite_step() generate an actual error code. Of the two I
think returning NULL is more within the spirit of SQL but I haven't though that
through yet.
Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
