Re: decode function

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: "gerard manvu " <manvu(dot)gerard4(at)caramail(dot)com>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: decode function
Date: 2003-12-09 19:28:36
Message-ID: 200312092028.36860.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

gerard manvu wrote:
> 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 'µ'.

That's the same thing. bytea stores bytes, not characters, so we expect
that you are primarily interested in the byte value.

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Kris Jurka 2003-12-09 21:07:45 Re: java.lang.NullPointerException - at
Previous Message Tom Lane 2003-12-09 14:31:48 Re: Error compiling PostgreSQL 7.4 for Fedora Core 1