Re: inconsistent behaviour of json_to_record and friends withembedded json
| От | Jeff Janes |
|---|---|
| Тема | Re: inconsistent behaviour of json_to_record and friends withembedded json |
| Дата | |
| Msg-id | CAMkU=1yjwaXTEDG3b-LC54s4y6BpmUsS8z-WvP8oA_ryukk8+w@mail.gmail.com обсуждение исходный текст |
| Ответ на | inconsistent behaviour of json_to_record and friends with embeddedjson (Robert Vollmert <rob@vllmrt.net>) |
| Ответы |
Re: inconsistent behaviour of json_to_record and friends withembedded json
Re: inconsistent behaviour of json_to_record and friends with embedded json |
| Список | pgsql-bugs |
On Thu, May 30, 2019 at 10:41 AM Robert Vollmert <rob@vllmrt.net> wrote:
1. select * from json_to_record('{"out": "{\"key\": 1}"}') as (out json);
...
Postgres 10/11:
1. gives
ERROR: invalid input syntax for type json
DETAIL: Token "key" is invalid.
CONTEXT: JSON data, line 1: "{“key…
This is caused by commit:
Author: Andrew Dunstan <andrew@dunslane.net>
Date: Thu Apr 6 22:11:21 2017 -0400
Make json_populate_record and friends operate recursively
As far as I can tell, this was not an intended change, so I agree it is probably a bug.
Cheers,
Jeff
В списке pgsql-bugs по дате отправления: