Re: [BUGS] decode function

2003-12-09 Thread Peter Eisentraut
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 a

[BUGS] decode function

2003-12-09 Thread gerard manvu
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