> 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: teodor@sigaev.ru WWW:
http://www.sigaev.ru/