decode function

From: "gerard manvu " <manvu(dot)gerard4(at)caramail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: decode function
Date: 2003-12-08 15:17:02
Message-ID: 1070896622022342@lycos-europe.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi
I don't know if it is really a bug or a missuse of postgresql but when I issue the following request
select decode(encode('µ'::bytea, 'escape'), 'escape');
, the result is \346, not 'µ'.
Any help or a forum link ?

Thanks in advance
Gerard.
PS: PostGreSQL 7.4, Red Hat 8, Base under SQL_ASCII or UNICODE (doesn't work either)

Les noms de domaine les moins chers du marché : 6,49 euros HT sur http://www.lycos.fr/pro .

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Seum-Lim Gan 2003-12-08 16:53:55 7.4 build error in Solaris
Previous Message Kris Jurka 2003-12-08 09:19:33 Re: String index out of range - Postgresql 7.3.4, Resin &