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