Re: accentuated letters in text-search
Guillaume Lelarge <guillaume@lelarge.info>
From: Guillaume Lelarge <guillaume@lelarge.info>
To: Andreas Joseph Krogh <andreak@officenet.no>
Cc: pgsql-hackers@postgresql.org
Date: 2010-07-22T05:42:03Z
Lists: pgsql-hackers
Le 21/07/2010 23:23, Andreas Joseph Krogh a écrit : > [...] > I was googling for how to create a text-seach-config with the following > properties: > - Map unicode accentuated letters to an un-accentuated equivalent > - No stop-words > - Lowercase all words > > And came over this from -general: > http://www.techienuggets.com/Comments?tx=106813 > > Then after some more googling I found this: > http://www.sai.msu.su/~megera/wiki/unaccent > > Any reason the unaccent dict. and function did not make it in 9.0? > Well, AFAICT, it's available in 9.0: http://www.postgresql.org/docs/9.0/static/unaccent.html -- Guillaume http://www.postgresql.fr http://dalibo.com