> Date: Sun, 15 Mar 2009 23:17:04 -0400 > From: "Griggs, Donald" <donald.gri...@allscripts.com> > Subject: Re: [sqlite] SQLITE : Constraint question
>> BTW, is there a document that explains in more detail what operations >> the CHECK constraint is capable of? [...] > Were you looking for something beyond the documentation under "CREATE > TABLE"? > > Column constraints: > http://www.sqlite.org/syntaxdiagrams.html#column-constraint > > Table constraints: > http://www.sqlite.org/syntaxdiagrams.html#table-constraint Well, all that these docs are saying concerning CHECK constraints is: "CHECK(expr)". So I looked up "expr" and there is indeed a lot of useful information, but I didn't see the typeof() function mentioned, for instance. Actually I wonder how to find out about this useful function if not by reading (and understanding ;-) the source code. > Conflict clause: > http://www.sqlite.org/syntaxdiagrams.html#conflict-clause > > Foreign key clause (enforceable with preprocessing to create triggers): > http://www.sqlite.org/syntaxdiagrams.html#foreign-key-clause Useful info, too, but not with respect to the CHECK statement (at least right now i can't see it). I understand that it's up to everybody to help improve the docs. So, as far as "strict affinity" is concerned, I'm planning on opening a ticket (that's how it works, right?) requesting a documentation improvement if there are no objections. Regarding the CHECK statement, however, I think that there is a gap that should be filled by someone with more insight than I have ... BTW: My previous post was my first post to this list, and I forgot to say Hello to everybody, and most of all: Hats off to Mr. Hipp, great work! :-) Best, Wolfgang Enzinger _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
