如何從 postgres 中的 json 中提取
[{"val":"2","dsk:"one"},{"val":"2","dsk":"two"},{"val":"3","dsk":"three"}]
dsk 值在哪里
它回傳空值
SELECT '[{"val":"2","dsk:"one"},{"val":"2","dsk":"two"},{"val":"3","dsk":"three"}]'::json->'dsk'
uj5u.com熱心網友回復：
您可以使用該jsonb_path_query_array函式并從陣列中提取整個值
select jsonb_path_query_array('[{"val":"2","dsk":"one"},{"val":"2","dsk":"two"},{"val":"3","dsk":"three"}]','$[*].dsk')
DBfiddle中的演示
uj5u.com熱心網友回復：
如前所述，您不能使用您的方法，因為它是一個陣列，但您可以使用 json 函式嘗試不同的方法：
WITH data
AS (
SELECT *
FROM json_array_elements('[{"val":"2","dsk":"one"},{"val":"2","dsk":"two"},{"val":"3","dsk":"three"}]'::json)
)
SELECT value->'dsk'
FROM data
轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/468886.html
標籤：json PostgreSQL
上一篇：如何在每個陣列中連接jq路徑
下一篇：如何制作貨幣搜索過濾器？