Re: Not found indexed word

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: Melek JARRAYA <MJARRAYA(at)cfirst(dot)fr>
Cc: Pg Bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: Not found indexed word
Date: 2018-08-21 03:39:36
Message-ID: CAMkU=1whHUjRJ78NDcdqV1o3PyWsFRtyXqZ0T6_cDEEG9Jph7Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Mon, Aug 20, 2018 at 5:55 AM, Melek JARRAYA <MJARRAYA(at)cfirst(dot)fr> wrote:

> 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.
>

"Pepiniere" has an 'e' at the end, and "Pepinier" does not. It is possible
one is supposed to converted to the other by the stemmer, but without
seeing the exact query you ran, it is hard to know.

Cheers,

Jeff

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message David Rowley 2018-08-21 05:46:56 Re: BUG #15343: Segmentation fault using pg_dump with --exclude-table if table contains identity column
Previous Message Amit Kapila 2018-08-21 03:14:31 Re: BUG #15324: Non-deterministic behaviour from parallelised sub-query