Ken <kennethinbox-sqlite-/[EMAIL PROTECTED]> wrote:
Some commecial products have "check constraints" that allow you to
enable a check on a column that can be stored procedural code. That
could also be another way of keeping "non-trimmed" data out.
I don't think sqlite supports column level check contstraints.
Does too.
create table test(txt CHECK(txt = trim(txt)));
insert into test(txt) values(' a '); -- constraint failed
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
