On Jun 10, 2012, at 2:35 PM, Wolfgang Meiners wrote: > So my question is: (how) can i write an integrity constraint in sqlite3
The short of it is that you can't. SQLite doesn't support such constraints. Only the basics are supported: primary, unique, referential, not null, check: http://www.sqlite.org/lang_createtable.html#constraints The check constraint can only contain basic expressions. In other words, no select statements. For anything more, hmmm, convoluted, you better stick to triggers or ETL. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users