Re: Cast text to bytea - Mailing list pgsql-admin

From Alvar Freude
Subject Re: Cast text to bytea
Date
Msg-id 1188410000.1070440421@gnarzelwicht.delirium-arts.de
Whole thread Raw
In response to Re: Cast text to bytea  (Godshall Michael <Michael_Godshall@gmachs.com>)
List pgsql-admin
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,

uups, why I wrote the originating mail  to pgsql-admin? Sorry!

- -- Godshall Michael <Michael_Godshall@gmachs.com> wrote:

> Have you seen this?
> http://www.postgresql.org/docs/current/static/datatype-binary.html

yes, but this only describe the bytea type, not how to cast some text. Or I
missed something ;) ...


> Maybe you need some backslashes?

this also doesn't help:

 odem=> SELECT 'abc'::text::bytea;
 ERROR:  Cannot cast type text to bytea
 odem=> SELECT '\000'::text::bytea;
 ERROR:  Cannot cast type text to bytea


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/zZ/lOndlH63J86wRAp6MAKCJrV6S8b0LKF3xpC9EHrEhz+/uVgCgukpf
sUZsrP3+u2Sxn0goxTGMAxY=
=+bY9
-----END PGP SIGNATURE-----


pgsql-admin by date:

Previous
From: Janko Richter
Date:
Subject: Re: downgrading to 7.3.2 from 7.4.1 under Cygwin
Next
From: Ferdinand Smit
Date:
Subject: Index problems