On Sat, Aug 18, 2012 at 10:00 AM, Mohit Sindhwani <m...@onghu.com> wrote:
> On 17/8/2012 7:14 PM, Dominique Pellé wrote:
>> This gives the tokens:
>>
>> sqlite> CREATE VIRTUAL TABLE ft USING fts4(x);
>> sqlite> INSERT INTO ft VALUES("hello world");
>> sqlite> INSERT INTO ft VALUES("hello there");
>>
>> sqlite> CREATE VIRTUAL TABLE ft_terms USING fts4aux(ft);
>>
>> sqlite> .header on
>> sqlite> SELECT * FROM ft_terms;
>> term|col|documents|occurrences
>> hello|*|2|2
>> hello|0|2|2
>> there|*|1|1
>> there|0|1|1
>> world|*|1|1
>> world|0|1|1
>
> Actually, I want to know:
> * terms for "hello world" are "hello" and "world"
> * terms for "hello there" are "hello" and "there"
> ...and so on.
>
> The aux table doesn't give an easy way to find that, as far as I can see.Depending on how often you need to do this, perhaps you could just create a table in the TEMP database or a memory database, and insert only a single document. -scott _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
