Re: json/jsonb inconsistence - 2 - Mailing list pgsql-hackers

From Teodor Sigaev
Subject Re: json/jsonb inconsistence - 2
Date
Msg-id 538764F6.6090400@sigaev.ru
Whole thread Raw
In response to Re: json/jsonb inconsistence - 2  (Andrew Dunstan <andrew@dunslane.net>)
List 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@sigaev.ru                                      WWW:
http://www.sigaev.ru/



pgsql-hackers by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Re: [COMMITTERS] pgsql: Fix bogus %name-prefix option syntax in all our Bison files.
Next
From: Josh Kupershmidt
Date:
Subject: Re: Odd uuid-ossp behavior on smew and shearwater