Re: BUG #14278: Problem searching spanish words with accent mark outside the stem - Mailing list pgsql-bugs

From Alvaro Herrera
Subject Re: BUG #14278: Problem searching spanish words with accent mark outside the stem
Date
Msg-id 20160808045847.GA878137@alvherre.pgsql
Whole thread Raw
In response to BUG #14278: Problem searching spanish words with accent mark outside the stem  (paco@hernandezgomez.com)
Responses Re: BUG #14278: Problem searching spanish words with accent mark outside the stem
Re: BUG #14278: Problem searching spanish words with accent mark outside the stem
List pgsql-bugs
paco@hernandezgomez.com wrote:

> Search without accent mark is not working correctly when the accent mark is
> outside the stem of the word.

I think it'd be better to apply unaccent() to both the stored text
before ts_vectorization and to the query terms.   That would reliably
remove all diacritics (eñes too, though I suppose nobody would search
for their ñandúes by writing nandú, so it's not as severe).


--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

pgsql-bugs by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: BUG #14150: Attempted to delete invisible tuple
Next
From: Jaime Casanova
Date:
Subject: Re: BUG #14278: Problem searching spanish words with accent mark outside the stem