Re: BUG #8407: json_populate_record case sensitivity - Mailing list pgsql-bugs

george.stragand@gmail.com escribió:

> create type testPop as (
>     FOOBAR int
> );

Your problem is that this identifier has been downcased.  This works:

alvherre=# create type testPop as (
alvherre(# "FOOBAR" int);
CREATE TYPE
alvherre=# select * from json_populate_record(null::testPop, '{"FOOBAR": 1}');
 FOOBAR
--------
      1
(1 fila)

--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services