In the new fts3.html, the statement: "each FTS3 table has a 'rowid' column that behaves like an INTEGER PRIMARY KEY, except that values remain unchanged if the database is rebuilt using the VACUUM command."
is incorrect; an INTEGER PRIMARY KEY column *does* remain unchanged during VACUUM, in contrast to a usual ROWID. It is unclear here if the FTS3 rowid does or does not change during vacuum. - John Brooks On Thu, Dec 3, 2009 at 4:15 PM, Nicolas Williams <nicolas.willi...@sun.com> wrote: > Use the glob operator. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
