嵌套json的查询

postgres=# SELECT  t.data->'objects'->1->'src' AS ct
FROM   reports as t
     , json_array_elements(t.data->'objects') o
WHERE concat(o->>'src') LIKE '%bar%'
;