Re: [sqlite] Specifying a nullable column

2012-06-12 Thread Paul Medynski
On 12-Jun-2012 08:08, Richard Hipp wrote: On Tue, Jun 12, 2012 at 7:04 AM, Paul Medynski wrote: Hi Kevin, I understand the 'NOT NULL' column constraint and the syntax diagram and text describe it quite well. What isn't described is whether or not specifying simply 'NULL' is truly supported.

Re: [sqlite] Specifying a nullable column

2012-06-12 Thread Richard Hipp
On Tue, Jun 12, 2012 at 7:04 AM, Paul Medynski wrote: > Hi Kevin, > > I understand the 'NOT NULL' column constraint and the syntax diagram and > text describe it quite well. What isn't described is whether or not > specifying simply 'NULL' is truly supported. For example, the following > create

Re: [sqlite] Specifying a nullable column

2012-06-12 Thread Paul Medynski
Hi Kevin, I understand the 'NOT NULL' column constraint and the syntax diagram and text describe it quite well. What isn't described is whether or not specifying simply 'NULL' is truly supported. For example, the following create table statement is accepted by SQLite and appears to behave as

Re: [sqlite] Specifying a nullable column

2012-06-11 Thread Kevin Benson
On Mon, Jun 11, 2012 at 10:35 AM, Paul Medynski wrote: > 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

[sqlite] Specifying a nullable column

2012-06-11 Thread Paul Medynski
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 c