Jonathan Bond-Caron wrote: > This would probably help: > > CREATE OR REPLACE FUNCTION norm_text_latin(character varying) > RETURNS character varying AS > $BODY$ > declare > p_str alias for $1; > v_str varchar; > begin > select translate(p_str, 'ÀÁÂÃÄÅ', 'AAAAAA') into v_str;
Hmm, why not simply use to_ascii() ? -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
