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 sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users