-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi,
uups, why I wrote the originating mail to pgsql-admin? Sorry! - -- Godshall Michael <[EMAIL PROTECTED]> 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----- ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly