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(
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, e.