Tested on 9.4b3, 9.4rc1, 9.5devel
select * from json_to_record('
{"id":1,"val":"josh","valry":["potter","chef","programmer"]}') as r(id
int, val text, valry text[]);
ERROR: missing dimension value
With some experimentation, I can't find any way to convert a JSON array
to an array field using json_to_record or json_to_recordset. I know
this worked back in January, though.
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com