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 <[EMAIL PROTECTED]> 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
