Re: Not found indexed word

Hello,

By Défault the application is in French, but also i have the opportunity to
change in English or German.Can this cause the problem ?
If yes you must have serval words that do not go back in the search but in
this case there is just the set of words (pepinier , pepini, pepini, pepin,
pepi , pep), that does not go back.

Best regards,
Cordialement,
JARRAYA Melek
Tel: 03 88 06 64 34

De : Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
A : "Melek JARRAYA" <MJARRAYA(at)cfirst(dot)fr>
Cc : Jeff Janes <jeff(dot)janes(at)gmail(dot)com>, Pg Bugs
<pgsql-bugs(at)postgresql(dot)org>
Date : 23/08/2018 16:43
Objet : Re: Not found indexed word

"Melek JARRAYA" <MJARRAYA(at)cfirst(dot)fr> writes:
> Here is in screenshot the query executed for the search for the word
> "Pepinier".
> The search result is always null.
> QueryWords contains the search word.

You seem to be using the single-argument form of to_tsquery, which
means that the way it stems the word is going to depend on the
setting of default_text_search_config. It looks like the stored
word was stemmed using the "french" setting, but maybe that's not
what prevails for your running application. I'd try executing
just "SELECT to_tsquery('Pepiniere')" from your application and
see what you get.

In some quick experiments here, I get 'pepinier' in French or
Spanish, but just 'pepini' in English or German. So that'd be
enough to prevent a match to a stored 'pepinier'.

regards, tom lane