postgres=# SELECT t.data->‘objects‘->1->‘src‘ AS ctFROM reports as t , json_array_elements(t.data->‘objects‘) oWHERE concat(o->>‘src‘) LIKE ‘%bar%‘;
嵌套json的查询
原文：http://www.cnblogs.com/flintlovesam/p/5551522.html
