BUG #13972: jsonb_to_record cant map camelcase keys - Mailing list pgsql-bugs

From zn@dbml.dk
Subject BUG #13972: jsonb_to_record cant map camelcase keys
Date
Msg-id 20160218131207.2660.88690@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #13972: jsonb_to_record cant map camelcase keys  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: BUG #13972: jsonb_to_record cant map camelcase keys  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      13972
Logged by:          Jacob Zneider
Email address:      zn@dbml.dk
PostgreSQL version: 9.4.5
Operating system:   OS x 10.11.3
Description:

Try the following:

select * from json_to_record('{"aA":1,"bB":[1,2,3],"c":"bar"}') as x(aA int,
bB text, c text)

first two columns will be empty.

select * from json_to_record('{"aa":1,"bb":[1,2,3],"c":"bar"}') as x(aA int,
bB text, c text)

All columns are mapped.

select * from json_to_record('{"aa":1,"bb":[1,2,3],"c":"bar"}') as x(aa int,
bb text, c text)

All columns are mapped.

pgsql-bugs by date:

Previous
From: tarkhil@over.ru
Date:
Subject: BUG #13971: SysV shm is used regardless of config
Next
From: harry.townsend@eflowglobal.com
Date:
Subject: BUG #13973: Constants resolved in then/else clauses