json_to_recordset not working with camelcase json keys

Поиск
Список
Период
Сортировка
От Daniel Kellenberger
Тема json_to_recordset not working with camelcase json keys
Дата
Msg-id 9e4b92c2c68d4c3b8c4cdf5aa11bc844@exchange01.one.nca
обсуждение исходный текст
Ответы Re: json_to_recordset not working with camelcase json keys  (Joe Conway <mail@joeconway.com>)
Список pgsql-bugs
Hi all,

We tried to extract from a json with camel case keys values, but unfortunat=
elly they are not mapped.

Testcase: (PostgreSQL 9.4.5)

select * from json_to_recordset('[{"aB":1,"bC":"foo"},{"aB":"2","cD":"bar"}=
]') as x(aB int, bC text);

Expected:
aB | bC
1   | foo
2   | null

Actual:
aB  | bC
null | null
null | null

Does anyone knows if this is a bug?
Thanks for any help.

Kind regards,
Daniel

--
Our software sets the course: http://nca.me/software

Daniel Kellenberger | daniel.kellenberger@netcetera.com | T +41 44 297 58 1=
4 |
Netcetera AG | 8040 Z?rich | Switzerland | http://netcetera.com |

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #13818: PostgreSQL crashes after cronjob runs as "postgres"
Следующее
От: Joe Conway
Дата:
Сообщение: Re: json_to_recordset not working with camelcase json keys