problem with to_ascii() function in version 8.3.3 - Mailing list pgsql-general

From Pavel Arnošt
Subject problem with to_ascii() function in version 8.3.3
Date
Msg-id 1be54ddd-3565-498e-93fc-85da648c0667@z72g2000hsb.googlegroups.com
Whole thread Raw
Responses Re: problem with to_ascii() function in version 8.3.3  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
List pgsql-general
Hi,

i have a problem with to_ascii() function in version 8.3.3. I have
read Mr. Gonzales's post at

http://groups.google.com/group/pgsql.general/browse_thread/thread/f74650e3b3248ff0/9f36fb072ea1dc98?lnk=gst&q=to_ascii#9f36fb072ea1dc98
and he managed to use to_ascii function with following command
sequence:

create table chartest ( c text);
insert into chartest (c) values ('á');
select to_ascii(encode(convert_to(c,'LATIN9'),'escape'),'LATIN9') from
chartest;

His output was:

to_ascii
----------
 a

but i'm getting:

 to_ascii
----------
 \341

What am I doing wrong? How to_ascii function should be used?

Regards
Pavel Arnošt

pgsql-general by date:

Previous
From: "Oscar Uribe"
Date:
Subject: Sequences
Next
From: Cyril SCETBON
Date:
Subject: Error when trying to drop a tablespace