Roger Binns schrieb: > [...] > > Lukas Haase wrote: >> additionally I would also accept the index being bigger. > > You could have a second FTS table where you store the keywords in reverse > order :-)
Hi, DAMN!! Damn, damn. Thank you for the great idea. But unfortunately I thought I could combine postfix and prefix. But with this method this is not possible either. For example, consider the german word "Telefonanschlusskabel" (consisting of "Telefon", "Anschluss", "Kabel"). In this case '*anschluss*' should also find "Telefonanschlusskabel". Or, to be more specific, any '*partial*' query should work. Actually I need to solve this problem somehow. One possibility would be to write a complete FTS system on my own but this is really not what I want... Regards, Luke _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users