Hi all,
I'm sure I'm doing something stupid here...
CREATE VIRTUAL TABLE example USING fts4(TOKEN, CONTEXT);
INSERT INTO example(TOKEN, CONTEXT) VALUES('one', 'This is just one
sentence.');
INSERT INTO example(TOKEN, CONTEXT) VALUES('two', 'This is just one
sentence. Sorry, it are two sentences.');
INSERT INTO example(TOKEN, CONTEXT) VALUES('three', 'More then three
words in one sentence.');
SELECT snippet(example, '[', ']') FROM example WHERE CONTEXT MATCH
(SELECT TOKEN FROM example);
this returns
This is just [one] sentence.
This is just [one] sentence. Sorry, it are two sentences.
More then three words in [one] sentence.
while I was hoping for
This is just [one] sentence.
This is just one sentence. Sorry, it are [two] sentences.
More then [three] words in one sentence.
Can anyone tell me what I'm doing wrong?
thanks
gert
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
