On Fri, Aug 12, 2011 at 12:05 AM, Michael Stephenson
<domehead...@gmail.com> wrote:
> If you use INTEGER PRIMARY KEY, that column becomes your rowids; this does
> not create a new, separate column in addition to the rowid column.
Indeed, but the INTEGER PRIMARY KEY column would count as a user
defined column and thus affect the FTS search :) The FTS table has all
text data, so I really do need to create a separate column for the
IDs.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
