Ok, thanks. I understand offset will come with a performance slowdown, but should be ok for my purpose.
However, how can I get the offset(s) as part of the rank function implementation? The FTS offsets function is private: SQLITE_PRIVATE void sqlite3Fts3Offsets(sqlite3_context*, Fts3Cursor*); Regards Ben Am 14.05.13 14:06 schrieb "Richard Hipp" unter <[email protected]>: >On Mon, May 13, 2013 at 12:25 PM, Stadin, Benjamin < >[email protected]> wrote: > >> Hi all, >> >> I need to implement a ranking that considers the search result's token >> distance (so either the actual character offset, or token offset from >>the >> beginning of the text). Is it possible to get/query this distance from >>the >> FTS4 index (either directly or via ft4saux), or would I have to parse >>the >> content of each text column? >> > >The offsets() function provides this information. >http://www.sqlite.org/fts3.html#offsets > >-- >D. Richard Hipp >[email protected] >_______________________________________________ >sqlite-users mailing list >[email protected] >http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
