Hi Alexey, tha Am 12. März 2012 22:14 schrieb Alexey Pechnikov <pechni...@mobigroup.ru>:
> See > http://www.sqlite.org/draft/fts3.html#fts4aux > > have already tried the fts4aux table. however, I would also need the number of occurrences of each term in each document. Therefore, like in the docs, not only *-- The following query returns this data:**--**-- apple | * | 1 | 1**-- apple | 0 | 1 | 1**-- banana | * | 2 | 2**-- banana | 0 | 2 | 2**-- cherry | * | 3 | 3**-- cherry | 0 | 1 | 1**-- cherry | 1 | 2 | 2**-- date | * | 1 | 2**-- date | 0 | 1 | 2**-- elderberry | * | 1 | 2**-- elderberry | 1 | 1 | 1**-- elderberry | 1 | 1 | 1* but a result table like this: Term |col |docid| occurences ------------------------------------------ -- apple | 0 | 1 | 1 -- banana | 0 | 2 | 1 -- cherry | 0 | 3 | 1 -- cherry | 1 | 1 | 1 -- cherry | 1 | 2 | 1 -- date | 0 | 2 | 2 -- elderberry | 0 | 3 | 1 -- elderberry | 1 | 3 | 1 Best, mario > 2012/3/13 Mario Annau <mario.an...@gmail.com>: > > Hello, > > > > unfortunately I have already posted this question on > > stackoverflow< > http://stackoverflow.com/questions/9657016/get-inverted-index-from-sqlite-fts-table > >, > > hope that this mailing list is right address. > > > > After I have implemented a full text search function in my application > > using Sqlite and FTS tables I would be interested > > in a (performant) way of retrieving the FULL inverted index (or large > part) > > out of my FTS (sub-)table. > > > > In effect - I would need a result table including the terms, docid's and > > number of occurences. > > > > I am actually searching for some basic code/examples to read the segdir / > > segments table (where the actual index is stored ) and construct my > > desired result table (in effect - the inverted index). But any solution > > which could retrieve the full (or large part of) my inverted index using > > queries including MATCH, MATCHINFO , etc. (sorry, I'm no Sqlite export) > > would be highly appreciated! > > > > Best, > > mario > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > > -- > Best regards, Alexey Pechnikov. > http://pechnikov.tel/ > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users