Postgres内部json更新

Question

{
"travel": {
"arrival": {
"time": "2020-09-03T10:05:00.000Z",
"type": "Contract",
"driver": "saman",
"provider": "ideal",
"vehicleno": null
},
"departure": {
"time": "2020-09-03 16:55",
"type": "Contract",
"driver": "saman",
"provider": null,
"vehicleno": null
}
},
"serviceend": "2020-09-03T11:15:00.000Z",
"costsheetno": "AA 67856",
"servicestart": "2020-09-03T10:10:00.000Z"
}

如何设置成本表->'旅行"->"离开'->'时间'=空？

Answer 1

您可以这样使用jsonb_set()：

jsonb_set(costsheet, '{travel,departure,time}', 'null')