Re: Not found indexed word

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.

Cordialement,
JARRAYA Melek
Tel: 03 88 06 64 34

Jeff Janes ---21/08/2018 05:39:39---On Mon, Aug 20, 2018 at 5:55 AM, Melek JARRAYA <MJARRAYA@cfirst.fr> wrote: > Hello,

De : Jeff Janes <jeff.janes@gmail.com>
A : Melek JARRAYA <MJARRAYA@cfirst.fr>
Cc : Pg Bugs <pgsql-bugs@postgresql.org>
Date : 21/08/2018 05:39
Objet : Re: Not found indexed word

Hello,

We are working on a projet in java 8 and we use the PostgreSQL 9.6 technology. Part of this project contains indexing and search, for that we user tsvector.
During the test we found that for a spécific word "Pepiniere" the result of the search is null, while the word is indexed in the data base.



If i search with the word Metz or Strasbourg, the word "Pepiniere" goes back well in the results.