Greg Maitrallain <greg.maitrallain@xxxxxxxxx> writes: > The problem is the writings contains many names of personnalities. For > example : Churchill (the database covers WWII). But when I try to search > for these names, nothing is found. > I tried many things, like this introduction : > http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/docs/tsearch-V2-intro.html > And I think the problem's root is that no lexem is found (I could even > say an empty lexem is found). I think you've misconfigured your dictionary list. You normally want to use an ispell dictionary together with some other one, like a snowball dictionary. Using it by itself means exactly that only words known to the dictionary will be indexed. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general