Re: Cast text to bytea

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,

- -- Alvar Freude <alvar(at)a-blast(dot)org> 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_gtree SET gid2=(DECODE(gid::text, 'escape'));
ERROR: decode: Bad input string for type bytea

hmmm ...

The text columns contains values from \x01 to \xff -- everything exept the
null byte.

So, hmmm, it seems I'm faster writing a small piece of Perl to convert this
then searching a solution ... ;)

Ciao
Alvar

- --
** Alvar C.H. Freude -- http://alvar.a-blast.org/
** Berufsverbot? http://odem.org/aktuelles/staatsanwalt.de.html
** ODEM.org-Tour: http://tour.odem.org/
** Informationsgesellschaft: http://www.wsis-koordinierungskreis.de/

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (FreeBSD)

iD8DBQE/za68OndlH63J86wRAmE/AKCCaQU/YDFNv6fnri6D7I6Q74ts7QCfcqE1
S+I44j/Lx3mots/pt5EWBJE=
=LVOG
-----END PGP SIGNATURE-----