pg 多次嵌套json解析
select device_id,
json_extract_path_text(json_extract_path_text(device_info, ‘deviceInfo’)::json,‘uuid’) uuid
from skypay.device
查询地理位置:http://postgis.net/docs/manual-2.5/ST_Distance.html
pg 多次嵌套json解析
select device_id,
json_extract_path_text(json_extract_path_text(device_info, ‘deviceInfo’)::json,‘uuid’) uuid
from skypay.device
查询地理位置:http://postgis.net/docs/manual-2.5/ST_Distance.html