Cool! I didn't think of doing that. I presume this would incur a performance
hit on insert/update to check the constraint and sqlite3_prepare* would return
SQLITE_CONSTRAINT if the check failed. Right?
RW
Ron Wilson, S/W Systems Engineer III, Tyco Electronics, 434.455.6453
If you want to place a restriction on a column such that it will only
hold an integer (for example) you can use a CHECK constraint.
CREATE TABLE example1(x INTEGER CHECK( typeof(x)='integer' ));
D. Richard Hipp
[email protected]
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
