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
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
