Re: have you feel anything when you read this ? - Mailing list pgsql-sql

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.