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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers