Hi,
I can use the offsets() function to determine the start locations of
phrase matches, but is there any straightforward way to determine the
end locations?
CREATE VIRTUAL TABLE test USING fts4();
INSERT INTO test VALUES ('i am what i am');
SELECT offsets(test) FROM test WHERE content MATCH '\"i...a*\"';
0 0 0 1 0 1 2 2 0 0 10 1 0 1 12 2
-- what I want to determine is the full range of the phrase match: (0, 14)
Do I need to parse the query expression myself to determine how many
tokens are in the phrase? Is there a function I can tap into for that?
Thanks,
Hamish
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
