postgres=# select  '["\u0000"]'::json->0;
 ?column?
----------
 "\u0000"
(1 row)

Time: 1,294 ms
postgres=# select  '["\u0000"]'::jsonb->0;
 ?column?
-----------
 "\\u0000"
(1 row)

It seems to me that escape_json() is wrongly used in jsonb_put_escaped_value(), right name of escape_json() is a escape_to_json().

--
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