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@xxxxxxxxxxxx> 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
