Re: BUG #14278: Problem searching spanish words with accent mark outside the stem

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