json_to_recordset not working with camelcase json keys

Hi all,

We tried to extract from a json with camel case keys values, but unfortunatelly 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(dot)kellenberger(at)netcetera(dot)com | T +41 44 297 58 14 |
Netcetera AG | 8040 Z?rich | Switzerland | http://netcetera.com |