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.
Thanks.
Best Regards,
Vinit Patel
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
