Alexey Pechnikov wrote:
> It's bad solution:
>
> sqlite> CREATE TABLE T1 (N INTEGER CHECK(+N >= 0));
> sqlite> INSERT INTO T1 VALUES('-5');
> sqlite> INSERT INTO T1 VALUES('q');
> sqlite> select N, typeof(N) from T1;
> -5|integer
> q|text
I wasn't proposing this as a solution. It was an experiment, an attempt to
illustrate what was going on. I though I made it clear - I even show that
negative values slip through this check ('q' would pass the original check,
too). I can only assume you haven't actually read my message before jumping in
to respond.
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
