problem with to_ascii() function in version 8.3.3

Поиск
Список
Период
Сортировка
От Pavel Arnošt
Тема problem with to_ascii() function in version 8.3.3
Дата
Msg-id 1be54ddd-3565-498e-93fc-85da648c0667@z72g2000hsb.googlegroups.com
обсуждение исходный текст
Ответы Re: problem with to_ascii() function in version 8.3.3  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
Список 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 по дате отправления:

Предыдущее
От: "Oscar Uribe"
Дата:
Сообщение: Sequences
Следующее
От: Cyril SCETBON
Дата:
Сообщение: Error when trying to drop a tablespace