On Jul 3, 2010, at 2:37 AM, Patel, Vinit wrote:
> Hi :
>
> I was wondering how the NEAR operator works for the SQL database.
> In the SQLite test suite, in test file fts3near.test, One of the
> test case is as follows
>
> //fts3near-3.1 test case
>
> db eval {
> DELETE FROM t1;
> INSERT INTO t1(content) VALUES( 'one two three two four six three
> six nine four eight twelve' );
> }
>
> do_test fts3near-3.1 {
> execsql {SELECT offsets(t1) FROM t1 WHERE content MATCH 'three NEAR/
> 1 one'}
> } {{0 1 0 3 0 0 8 5}}
>
> I really got confused looking at the output set, what do the digits
> mean?
> Can someone please throw light on this keyword "NEAR" for this FTS3
> feature of SQLite.
The "offsets" function:
http://www.sqlite.org/fts3.html#section_4
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
