Re: RFC: i18n2ascii(TEXT) stored procedure - Mailing list pgsql-sql

From Manuel Sugawara
Subject Re: RFC: i18n2ascii(TEXT) stored procedure
Date
Msg-id m34qz0pg5s.fsf@conexa.fciencias.unam.mx
Whole thread Raw
In response to RFC: i18n2ascii(TEXT) stored procedure  (Michael A Nachbaur <mike@nachbaur.com>)
Responses Re: RFC: i18n2ascii(TEXT) stored procedure  (Michael A Nachbaur <mike@nachbaur.com>)
List pgsql-sql
Michael A Nachbaur <mike@nachbaur.com> writes:

> b) is there a better and/or faster way of implementing this?  I
> don't want searches to bog down (at least too badly) as a result of
> this.

Use to_ascii(text),

masm=# select to_ascii('áéíóú');to_ascii
----------aeiou
(1 row)

Regards,
Manuel.


pgsql-sql by date:

Previous
From: Michael A Nachbaur
Date:
Subject: RFC: i18n2ascii(TEXT) stored procedure
Next
From: Michael A Nachbaur
Date:
Subject: Re: RFC: i18n2ascii(TEXT) stored procedure