I've setup a database using tsearch2, configured with support for compound
words according to the excellent guide found here:
http://www.sai.msu.su/~megera/oddmuse/index.cgi/Tsearch_V2_compound_words
This works fine. There is however one drawback that I'd like to know
whether can be remedied. Let's say I want to search for records containing
the word 'fritekst', which is a compound Norwegian word meaning
'free text'.
testdb=# select to_tsquery('default_norwegian', 'fritekst');
to_tsquery
------------------------------
'fritekst' | 'fri' & 'tekst'
(1 row)
Now, this will indeed match those records, but it will also match any
records containing both of the words 'fri' and 'tekst', without regard
to whether they are next to each other or in completely different parts
of the text being indexed. In many situations, this will lead to a lot
of 'false' matches, seen from a user perspective.
Ideas on how to handle this problem will be much appreciated.
--
Lars Haugseth
"If anyone disagrees with anything I say, I am quite prepared not only to
retract it, but also to deny under oath that I ever said it." -Tom Lehrer