On 11.01.2006, at 02:55, [EMAIL PROTECTED] wrote:
SQLite version 3.3.0 is now available on the website http://www.sqlite.org/ Version 3.3.0 incorporates many enhancements and changes. Among the changes in this release: * CHECK constraints are now enforced.
could someone please elaborate on this one? sqlite> create table t (a int primary key, b int, check(0<b<1000)); sqlite> insert into t(b) values(100000000); does not complain, so what checks exactly can we do now? I couldn't find anything about this on the website. thanks, -Markus --- Markus W. Weissmann http://www.mweissmann.de/ http://www.opendarwin.org/~mww/
