json_to_recordset not working with camelcase json keys - Mailing list 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 |