BUG #13972: jsonb_to_record cant map camelcase keys

From: zn(at)dbml(dot)dk
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #13972: jsonb_to_record cant map camelcase keys
Date: 2016-02-18 13:12:07
Message-ID: 20160218131207.2660.88690@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 13972
Logged by: Jacob Zneider
Email address: zn(at)dbml(dot)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.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Alvaro Herrera 2016-02-18 13:30:36 Re: BUG #13970: Vacuum hangs on particular table; cannot be terminated - requires `kill -QUIT pid`
Previous Message tarkhil 2016-02-18 12:43:00 BUG #13971: SysV shm is used regardless of config