I was trying to follow the documentation on FTS4 and found what I guess is a typo.
In several places there is a reference to "document" where I believe it should be "documents" as the first term doesn't exist in any create statement. There are several of these in Appendix A http://www.sqlite.org/fts3.html#matchinfo CREATE VIRTUAL TABLE documents USING fts3(title, content); -- Assuming the application has supplied an SQLite user function named "countintegers" -- that returns the number of space-separated integers contained in its only argument, -- the following query could be used to return the titles of the 10 documents that contain -- the greatest number of instances of the users query terms. Hopefully, these 10 -- documents will be those that the users considers more or less the most "relevant". SELECT title FROM documents WHERE documents MATCH <query> ORDER BY countintegers(offsets(document)) DESC LIMIT 10 OFFSET 0 Michael D. Black Senior Scientist NG Information Systems Advanced Analytics Directorate _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users