Re: [sqlite] number of term occurances in fts3

On Mon, Dec 8, 2008 at 8:26 AM, Jos van den Oever <[EMAIL PROTECTED]> wrote: > Can one retrieve the number of times a certain term occurs in an fts table? > This can be useful for autocompletion comboboxes. Unfortunately, this information isn't tracked in an easy-to-expose fashion. It would be

[sqlite] number of term occurances in fts3

Hi all, Can one retrieve the number of times a certain term occurs in an fts table? This can be useful for autocompletion comboboxes. An example query could look like this: select term, count(term) c from myfts3table where myfts3table match 'h*'; term|c hi|10 hello|20 The snippet function is