BUG #8407: json_populate_record case sensitivity

From: george(dot)stragand(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #8407: json_populate_record case sensitivity
Date: 2013-08-29 21:08:56
Message-ID: E1VF9Sa-0002e2-J7@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: 8407
Logged by: Possible bug with json_populate_record?
Email address: george(dot)stragand(at)gmail(dot)com
PostgreSQL version: 9.3rc1
Operating system: Ubuntu
Description:

Using PostgreSQL 9.3beta2.

SELECT version();

PostgreSQL 9.3beta2 on x86_64-unknown-linux-gnu, compiled by gcc
(Ubuntu/Linaro 4.6.3-1ubuntu5) 4.6.3, 64-bit

The question is regarding json keys in uppercase. Here's a small example:

create type testPop as (
foobar int
);

This returns as expected:

select * from json_populate_record(null::testPop, '{"foobar": 1}');

Whereas this form, upper-cased version of foobar, returns an empty record.

select * from json_populate_record(null::testPop, '{"FOOBAR": 1}');

That could be working as designed, as 'foobar' != 'FOOBAR', and is
completely acceptable.

So, drop the type and recreate it with these statements:

drop type testPop;

create type testPop as (
FOOBAR int
);

And this form will still return an empty record:

select * from json_populate_record(null::testPop, '{"FOOBAR": 1}');

Again, this could be 100% working as designed per the contract of column
names. That's acceptable, but then the question is how to match keys
expressed as uppercase. The source of the json is from an external vendor,
so not something we can go back and change directly.

Thank you.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Alvaro Herrera 2013-08-29 23:09:06 Re: BUG #8407: json_populate_record case sensitivity
Previous Message Kevin Grittner 2013-08-29 14:57:33 Re: BUG #8394: SQL command REINDEX doesn't work