Thread: decode function

Hi
I don't know if it is really a bug or a missuse of postgresql but when I is=
sue the following request
select decode(encode('=B5'::bytea, 'escape'), 'escape');
, the result is \346, not '=B5'.
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 wor=
k either)

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

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.