Re: cast bytea to text

yep, sry it took me a while to answer. It works now.
here´s my code:
-- start code --
create or replace function bytea2text(bytea) returns text as
$$
select ENCODE($1, 'escape');
$$
language sql strict;

create cast (bytea as text)
with function bytea2text(bytea)
as implicit;
-- end code --

thanks!

Willy-Bas Loos

On 3/1/07, Albe Laurenz <all(at)adv(dot)magwien(dot)gv(dot)at> wrote:
>
> > How can i cast bytea to text?
> > I´ve read about the DECODE function, but my 8.1 backend
> > doesn´t recognize it.
> > I´m trying to create an implicit cast using the function:
> >
> > create or replace function bytea2text(bytea) returns text as
> > $$
> > select DECODE($1, 'escape');
> > $$
> > language sql strict;
> >
> > Answer:
> > ERROR: function decode(bytea, "unknown") does not exist
>
> Try ENCODE instead of DECODE ...
>
> Yours,
> Laurenz Albe
>