Re: how to read bytea field

Decode works as expected for me....

Try the following:

select decode((encode(E'\\000\\001', 'escape')::text), 'escape');

-----------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)

On 1/24/07, marcelo Cortez <jmdc_marcelo(at)yahoo(dot)com(dot)ar> wrote:
>
> hi Markus ,folks
>
>
>
>
> > Are you sure you tested with a real bytea field?
>
> Yeah , i store bytea using encode function , how you
> say .
> The field of my table is bytea type , and store real
> bytea data in this field.
> My problem is , i can't convert this field to text
> anymore, not function receiving bytea and return text
> exist's.
> I think my mistake was use bytea field.
> I thinking in turn this field to text and use
> decode/encode for storage binary data.
> please correct me if i'm wrong.
> best regards
> mdc
>
>
>
>
>
> >
> > Regards
> >
> > Markus
> >
> >
> > ---------------------------(end of
> > broadcast)---------------------------
> > TIP 5: don't forget to increase your free space map
> > settings
> >
>
>
>
>
>
>
>
> __________________________________________________
> Preguntá. Respondé. Descubrí.
> Todo lo que querías saber, y lo que ni imaginabas,
> está en Yahoo! Respuestas (Beta).
> ¡Probalo ya!
> http://www.yahoo.com.ar/respuestas
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>