I've searching and reading quite a bit in the archives: So far I found the proposal of a "rank" column
http://www.nabble.com/Ranking-in-fts.-td11034641.html Also Scott mentioned the internal "dump_terms" and "dumpt_doclist" functions http://www.nabble.com/FTS-statistics-and-stemming-td18298526.html But this all doesn't seem to be the definite answer yet. So is there a way to rank FTS3 results in sqlite? ..or is someone working on this? cheers -- Torsten _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users