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

O Peter Eisentraut έγραψε στις Mar 20, 2006 :

> Eugene E. wrote:
> > the bytea does not output NULs at all.
> > don't mock me.
> 
> peter=# create table test (a bytea);
> CREATE TABLE
> peter=# insert into test values ('a\\000b');
> INSERT 0 1
> peter=# select * from test;
>    a
> --------
>  a\000b

Just did

dynacom=# SELECT '\150\145\154\154\157'::text;text
-------hello
(1 row)

dynacom=#
dynacom=#
dynacom=# SELECT '\000\150\145\154\154\157'::text;text
------

(1 row)

dynacom=#         

Oops!

> 
> 

-- 
-Achilleus