Обсуждение: unaccent as stored procedure?

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.

Thanks,
   -Steve

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