From: | Teodor Sigaev <teodor(at)sigaev(dot)ru> |
---|---|
To: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
Cc: | Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: json/jsonb inconsistence - 2 |
Date: | 2014-05-29 16:48:54 |
Message-ID: | 538764F6.6090400@sigaev.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> 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(at)sigaev(dot)ru
WWW: http://www.sigaev.ru/
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Kupershmidt | 2014-05-29 17:20:04 | Re: Odd uuid-ossp behavior on smew and shearwater |
Previous Message | Jeff Janes | 2014-05-29 16:39:56 | recovery testing for beta |