select replace( replace( replace( replace( 'Test � � � �', '�','ae'), '�','oe' ), '�','ue'), '�','ss' );
Thanks a lot. A wrote this into a user defined function with lower() around the source string, and it works. :-)
CREATE OR REPLACE FUNCTION public.unumlaut(varchar)
RETURNS varchar AS
'select replace( replace( replace( replace( lower($1), \'�\',\'ae\'), \'�\',\'oe\' ), \'�\',\'ue\'), \'�\',\'ss\' );'
LANGUAGE 'sql' IMMUTABLE STRICT;
Best regards, Robert. :)
-- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Robert Str�tgen mailto:[EMAIL PROTECTED] http://www.stroetgen.de/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
