Re: [sqlite] How can I count the number of times a word present in text indexed with FTS 3?

2008-06-18 Thread Scott Hess
There is not currently any support for this in fts. Put another way, you can count the words like you'd count them without fts :-). Long-term, I do plan to add support for figuring out some meta-information about tokens across the index, but there's nothing really driving that at this time.

[sqlite] How can I count the number of times a word present in text indexed with FTS 3?

2008-06-10 Thread Tito Ciuro
Hello, I was reading the document 'http://www.sqlite.org/cvstrac/wiki?p=FtsUsage' and I was wondering whether there is a way to count the number of times a word is present in text indexed with FTS 3. For example: CREATE VIRTUAL TABLE recipe USING fts3(name, instructions); INSERT INTO