--- Adam Megacz <[EMAIL PROTECTED]> wrote:
> Hello, I need to create a perpetually-unique column in an FTS2 table.
> For example:
>
> create virtual table t using fts2(c);
> insert into t (c) values ('a');
> select rowid,c from t;
> 1|a
> delete from t;
> insert into t (c) values ('b');
> select rowid,c from t;
> 1|b
>
> How can I get the last query to return some value other than "1" (the
> column need not be called ROWID; any name will work)?
Presumably fts3 will support a column along the lines of:
id INTEGER PRIMARY KEY AUTOINCREMENT
____________________________________________________________________________________
Got a little couch potato?
Check out fun summer activities for kids.
http://search.yahoo.com/search?fr=oni_on_mail&p=summer+activities+for+kids&cs=bz
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
