X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.130])
	by svr1.postgresql.org (Postfix) with ESMTP id 86018D1B4E3
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 26 Sep 2003 00:00:02 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new,
	port 10024) with ESMTP id 81144-09
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu, 25 Sep 2003 20:59:33 -0300 (ADT)
Received: from conexa.fciencias.unam.mx (conexa.fciencias.unam.mx
	[132.248.109.170])
	by svr1.postgresql.org (Postfix) with ESMTP id 1DF54D1B509
	for <pgsql-sql@postgresql.org>; Thu, 25 Sep 2003 20:59:29 -0300 (ADT)
Received: (from masm@localhost)
	by conexa.fciencias.unam.mx (8.11.6/8.11.6) id h8Q068807758;
	Thu, 25 Sep 2003 19:06:08 -0500
X-Authentication-Warning: conexa.fciencias.unam.mx: masm set sender to
	masm@fciencias.unam.mx using -f
To: Michael A Nachbaur <mike@nachbaur.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: RFC: i18n2ascii(TEXT) stored procedure
References: <200309251650.53855.mike@nachbaur.com>
In-Reply-To: <200309251650.53855.mike@nachbaur.com>
From: Manuel Sugawara <masm@fciencias.unam.mx>
User-Name: Manuel Sugawara
User-Mail-Address: masm@fciencias.unam.mx
Date: 25 Sep 2003 19:06:07 -0500
Message-ID: <m34qz0pg5s.fsf@conexa.fciencias.unam.mx>
Lines: 16
User-Agent: Gnus/5.0808 (Gnus v5.8.8) XEmacs/21.4 (Common Lisp)
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200309/318
X-Sequence-Number: 15296

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=3D# select to_ascii('=E1=E9=ED=F3=FA');
 to_ascii
----------
 aeiou
(1 row)

Regards,
Manuel.