Maybe this is old, but there is - as far as I understand the descriptions and the results - an error in the fts documentation. In section 4.3 http://www.sqlite.org/fts3.html#matchinfo in the example it says:
"-- The format string for this query is "nl". The output array will therefore -- contain 3 integer values - 1 for "n" and 2 for "l". The query returns -- two rows (the first two rows in the table match). The values returned are: -- -- 3 1 1 -- 3 2 0 -- -- The first value in the matchinfo array returned for both rows is 3 (the -- number of rows in the table). The following two values are the lengths -- of the longest common subsequence of phrase matches in each column. SELECT matchinfo(t1, 'nl') FROM t1 WHERE t1 MATCH 'default transaction';" Isn't that an "s" instead of "l"? Best regards. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users