| From: | Teodor Sigaev <teodor(at)sigaev(dot)ru> |
|---|---|
| To: | Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | json/jsonb inconsistence - 2 |
| Date: | 2014-05-29 12:00:54 |
| Message-ID: | 53872176.3000609@sigaev.ru |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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: teodor(at)sigaev(dot)ru
WWW: http://www.sigaev.ru/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rahila Syed | 2014-05-29 12:11:07 | Re: Compression of full-page-writes |
| Previous Message | Teodor Sigaev | 2014-05-29 11:55:47 | json/jsonb inconsistence |