MatheusOl helped me solve this on IRC, sending it here in case it helps
someone looking at the archives of the mailing list.
Here is a test case
create table t(id SERIAL, event json);
insert into t(event) VALUES ('{type:show, products: [ { id :
1, name : p1}] }'::json);
insert into t(event)
Hi,
here is an example of a problem I encounter with json_populate_recordset
because it does not support nested object. Actually, I would prefer that it
ignores nested object rather than raise an error, as it fails on a key I
don't even want to use!
Here's the query:
select e.timestamp::date,