json/jsonb inconsistence - 2

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/

Responses

Browse pgsql-hackers by date

  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