--- Ralf Junker <[EMAIL PROTECTED]> wrote:
> This one just came to my mind:
>
> CREATE TABLE (rowid INTEGER PRIMARY KEY, t TEXT);
>
> This promotes "rowid" to a visible column "rowid" which does not change
> during a VACUUM. "rowid"
> is already a reserved word in SQLite. Maybe this option is even compatible to
> FTS2?
Making rowid public changes the default INSERT behavior of a table.
sqlite> create table t(a);
sqlite> insert into t values(1);
sqlite> drop table t;
sqlite> create table t(rowid INTEGER PRIMARY KEY, a);
sqlite> insert into t values(1);
SQL error: table t has 2 columns but 1 values were supplied
But if you always use named columns for INSERT, you would be okay.
____________________________________________________________________________________
Sick sense of humor? Visit Yahoo! TV's
Comedy with an Edge to see what's on, when.
http://tv.yahoo.com/collections/222
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
