Re: [GENERAL] Cast text to bytea

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, - -- Alvar Freude <[EMAIL PROTECTED]> wrote: > But it seems that Postgres can't cast text to bytea: > > odem=> UPDATE forum_gtree SET gid2=gid::bytea; > ERROR: Cannot cast type text to bytea I tryed it with DECODE: odem=> UPDATE forum_gtr

[GENERAL] Cast text to bytea

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, I want to change a column from text to bytea; since it seems that alter table can't change the column type, i have to add a temporary column and copy the data from the old one to the new, delete the old and rename the new. But it seems that Post