On Thu, Aug 11, 2011 at 2:48 PM, Abhinav Upadhyay < er.abhinav.upadh...@gmail.com> wrote:
> 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. > Every FTS table has a "docid" column that is not searched, that is a unique integer key (like rowid), and which is not modified by VACUUM. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users