On 7/16/07, Adam Megacz <[EMAIL PROTECTED]> wrote:
Is there any way to use a INTEGER PRIMARY KEY AUTOINCREMENT on a table that has FTS2? Specifying it in the obvious manner looks like it works, but the column just ends up with nulls in it.
In fts tables all columns other than rowid are of type TEXT. It doesn't matter what you put in the type, they will be of type TEXT. The rowid is the standard SQLite rowid, so it does provide an INTEGER PRIMARY KEY AUTOINCREMENT column. The standard way to have non-TEXT information associated with rows in an fts table would be a separate table which joins with the fts table on rowid. -scott ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------