Keith Roberts wrote: > I'm trying to learn the syntax for SQLite, and I'm getting > stuck with the type-def production in: > > http://www.sqlite.org/lang_createtable.html > > Should name not be a selection of available type names, > instead of an iteration?
With SQLite, there is no exhaustive list of "available type names". For more details, see http://www.sqlite.org/datatype3.html > Can a type-name be followed by a signed number? Yes. This is allowed for compatibility with other databases, which often support types like CHAR(100) or NUMERIC(10, 2). SQLite accepts these numbers in the syntax, but doesn't act on them in any way; they are simply ignored. Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
