palmer ristevski <[EMAIL PROTECTED]> wrote: > Say one defines a column to be of text type, > but you want only 'text' to contain only alphabetic characters, > no numeric characters, how would one create this rule and enforce it > in SQLite SQL or does one have to use triggers.
Perhaps something like this: create table t(x check (ltrim(x, 'ABC...Zabc...z') = '')); (with full alphabet in place of ellipsis, of course). > Another question I have is, has proper referential integrity been > finally established > and things like full joins and other joins. No. Still no foreign keys, and only left outer joins. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
