Re: BUG #8407: json_populate_record case sensitivity

From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: george(dot)stragand(at)gmail(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #8407: json_populate_record case sensitivity
Date: 2013-08-29 23:09:06
Message-ID: 20130829230906.GB7540@eldon.alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

george(dot)stragand(at)gmail(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Andres Freund 2013-08-29 23:11:38 Re: BUG #8407: json_populate_record case sensitivity
Previous Message george.stragand 2013-08-29 21:08:56 BUG #8407: json_populate_record case sensitivity