Re: decode function - Mailing list pgsql-bugs

From Peter Eisentraut
Subject Re: decode function
Date
Msg-id 200312092028.36860.peter_e@gmx.net
Whole thread Raw
In response to decode function  ("gerard manvu " <manvu.gerard4@caramail.com>)
List 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.

pgsql-bugs by date:

Previous
From: "Chad N. Tindel"
Date:
Subject: Unintended shutdown in postgres 7.4
Next
From: Kris Jurka
Date:
Subject: Re: java.lang.NullPointerException - at