Actually, this is just the tip of the iceberg.


Funny, but
postgres=# select '\u0000'::text;
  text
--------
 \u0000
(1 row)

postgres=# select array['\u0000']::text[];
    array
-------------
 {"\\u0000"}

postgres=# select '{"\u0000"}'::text[];
  text
---------
 {u0000}

postgres=# select '{"\\u0000"}'::text[];
    text
-------------
 {"\\u0000"}

&%) I'm crazy about that. Suppose, we shouldn't worry about array type, just make output the same for json/jsonb
--
Teodor Sigaev                      E-mail: teo...@sigaev.ru
                                      WWW: http://www.sigaev.ru/


--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to