According do
http://www.sqlite.org/fts3.html#matchinfo

sqlite3 test.sqlite3

CREATE VIRTUAL TABLE t1 USING fts4(a, b);
INSERT INTO t1 VALUES('transaction default models default', 'Non
transaction reads');
INSERT INTO t1 VALUES('the default transaction', 'these semantics present');
INSERT INTO t1 VALUES('single request', 'default data');

SELECT matchinfo(t1) FROM t1 WHERE t1 MATCH 'default transaction "these
semantics"';

Should result in:

3 2  1 3 2  0 1 1  1 2 2  0 1 1  0 0 0  1 1 1

However, I get back an empty string.

SELECT matchinfo(t1, 'ns') FROM t1 WHERE t1 MATCH 'default transaction';

returns two empty strings

sqlite3 --version
3.7.13 2012-06-11 02:05:22 f5b5a13f7394dc143aa136f1d4faba6839eaa6dc

AJ ONeal
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to