Re: [sqlite] virtual tables may not be indexed

On Wed, Aug 5, 2009 at 5:37 PM, Lukas Haase wrote: > Hi list, > > I have a huge problem: A database with 2 HTML fragements should > contain a fulltext index. For that reason I put all data into a virtual > table: > > CREATE VIRTUAL TABLE topics USING fts3( >        topicID

Re: [sqlite] virtual tables may not be indexed

fts has an implicit index on the docid (aka rowid), and a fulltext index on the terms in the columns. All columns are treated as TEXT, you can say INTEGER or VARCHAR, but they are TEXT. The end of this page: http://code.google.com/apis/gears/api_database.html has an example of how you might

[sqlite] virtual tables may not be indexed

Hi list, I have a huge problem: A database with 2 HTML fragements should contain a fulltext index. For that reason I put all data into a virtual table: CREATE VIRTUAL TABLE topics USING fts3( topicID INTEGER, topic_title VARCHAR(200) COLLATE NOCASE, topic TEXT,