Hi folks,

I notice that the syntax diagram for 'create table' shows the 'column-constraint' definition as requiring 'null' to always be preceded by 'not'. I don't see any definition that supports just 'null'. However, when using SQLite3 3.7.3 or 3.7.9, I can create a table and specify any column as "Foo <type> null", and it works as expected allowing the column to contain null values.

Is the syntax diagram simply out of date, or am I doing something that appears to work, but will bite me in the end? :)

Thanks,
-Paul

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to