unaccent as stored procedure?

On Mon, 4 Dec 2006, Stephen Woodbridge wrote:

Hi all,

I was wondering if anyone has unac.c which is the lib used in Text::Unaccent
built and wrap as a plpgsql stored procedure not using plperl. Or maybe there
is another general solution that I am no aware of.

I have one, don't remember whet did I get it.

Thanks,
-Steve

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83

Stephen Woodbridge a écrit :

Or maybe there is another general solution that I am no aware of.

If you just want to remove accents from your string, you can
use :
to_ascii(convert(<mystring>, 'LATIN9'), 'LATIN9')
It works very well AFAIAC.

(tip given on this list)

--
Arnaud