Re: json_to_recordset not working with camelcase json keys

Hi Joe

Thanks for your answer, this solved our issue.
In one project we are currently switching from Oracle to PostgreSQL and are excited about the database.

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 |

________________________________________
Von: Joe Conway <mail(at)joeconway(dot)com>
Gesendet: Mittwoch, 16. Dezember 2015 00:17
An: Daniel Kellenberger; pgsql-bugs(at)postgresql(dot)org
Betreff: Re: [BUGS] json_to_recordset not working with camelcase json keys

On 12/15/2015 01:46 PM, Daniel Kellenberger wrote:
> 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);

Not a bug, I believe. You probably meant this:

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

Unquoted identifiers are lowercased in postgres, so for camel case
identifiers you would need double quotes.

HTH,

Joe

--
Crunchy Data - http://crunchydata.com
PostgreSQL Support for Secure Enterprises
Consulting, Training, & Open Source Development