[sqlite] Savepoint Questions

Hello all, I have some questions and comments about savepoints, documented here: https://www.sqlite.org/lang_savepoint.html Here are some excerpts from that documentation that are relevant to my questions/comments: 1. "The SAVEPOINT command starts a new transaction with a name. The

Re: [sqlite] Specifying a nullable column

On 12-Jun-2012 08:08, Richard Hipp wrote: On Tue, Jun 12, 2012 at 7:04 AM, Paul Medynski<pmedyn...@rim.com> 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

Re: [sqlite] Specifying a nullable column

, -Paul On 11-Jun-2012 15:35, Kevin Benson wrote: On Mon, Jun 11, 2012 at 10:35 AM, Paul Medynski<pmedyn...@rim.com> 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

[sqlite] Specifying a nullable column

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