On Mar 6, 2013, at 10:24 PM, Nico Williams <n...@cryptonector.com> wrote:

> Nah, use this sort of CHECK constraint:
> 
> CREATE TABLE toy(a INTEGER CHECK(a = CAST(a AS INTEGER)));

Hmmm… on second thought… is that an assignment in that check constraint?!? I.e. 
are you reassigning a to a new cast value?!?

Are not check constraint suppose to be boolean expression? 

Dazed and confused.

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

Reply via email to