On 27 February 2012 17:11, Hamish Allan <ham...@gmail.com> wrote:
>
> -- what I want to determine is the full range of the phrase match: (0, 14)
Sorry, correction: I want the full range*s* of the phrase match: (0,
4) and (12, 4).
H
On 27 February 2012 17:11, Hamish Allan <ham...@gmail.com> wrote:
> 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
