On 17/03/2009 9:02 AM, Wolfgang Enzinger wrote: >> 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.
Don't wonder. It's on the same page as all the other core functions: http://www.sqlite.org/lang_corefunc.html _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
