解析大字段表:
数据:{"childForm1":{"bgt_perf_goal_data":[{"item__gradedSummaryId":"123","item__level":1,"item__pcode":"","deptFunc":"333","item__gradedSummaryNestId":"21312321","deptFunc__viewSort":"123","_XID":"3","rowIndex":0,"id":2,"last__level":4}]}}
获取:SELECT datas::json -> 'childForm1' -> 'bgt_perf_goal_data'-> 0 -> 'deptFunc' as deptFunc
FROM sc_pems.bgt_perf_goal_data
PostgreSQL获取json数组里面的某个key对应的value
最新推荐文章于 2024-05-29 17:20:58 发布