On Dec 4, 2009, at 7:28 AM, John Brooks wrote:
> 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.
Changed to:
", each FTS3 table has a "rowid" column. The rowid of an FTS3 table
behaves in the same way as the rowid column of an ordinary SQLite
table, except that the values stored in the rowid column of an FTS3
table remain unchanged if the database is rebuilt using the VACUUM
command."
Dan.
>
> - 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
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
