paco(at)hernandezgomez(dot)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