Achilleus Mantzios wrote:
> dynacom=# SELECT '\000\150\145\154\154\157'::text;
> text
> ------
>
> (1 row)
>
> dynacom=#
>
> Oops!
text is not bytea.
alvherre=# SELECT $$\000\150\145\154\154\157$$::bytea;
bytea
-----------
\000hello
(1 fila)
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.