On Wed, Mar 6, 2013 at 3:43 PM, Petite Abeille <petite.abei...@gmail.com> wrote: > On Mar 6, 2013, at 10:24 PM, Nico Williams <n...@cryptonector.com> wrote: >> 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?!?
No. The only place where = is an assignment is in UPDATE statements, in the SET clause. > Are not check constraint suppose to be boolean expression? It is. That's an equality operator. Nico -- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
