PostgreSQL 12.17从JSON数组提取元素

早上好

PostgreSQL版本12.17

我有一个名为"design"的列，其中包含JSON数组数据.

column

此列中存储的JSON格式如下:

{
    "objectVersion": 0,
    "design": [
        {
            "setNumber": true,
            "objectVersion": 0,
            "type": "RULE_PART",
            "number": 0,
            "operator": "EQUAL",
            "left": {
                "objectVersion": 0,
                "type": "RESOLVED",
                "value": "94068ff0-e73e-4f99-9f66-7025bf14ffb4.Ce6188690-7495-4bd0-a9c6-91ef98acb64a",
                "resolverType": "FORM",
                "_type": "RulePartOperand"
            },
            "right": {
                "objectVersion": 0,
                "type": "LITERAL",
                "value": "N",
                "resolverType": null,
                "_type": "RulePartOperand"
            },
            "combine": "AND",
            "subParts": [],
            "_type": "RulePart"
        },
        {
            "setNumber": true,
            "objectVersion": 0,
            "type": "RULE_PART",
            "number": 1,
            "operator": "EQUAL",
            "left": {
                "objectVersion": 0,
                "type": "RESOLVED",
                "value": "94068ff0-e73e-4f99-9f66-7025bf14ffb4.C292d1bbe-cfc0-4736-a164-70882714cbf0",
                "resolverType": "FORM",
                "_type": "RulePartOperand"
            },
            "right": {
                "objectVersion": 0,
                "type": "LITERAL",
                "value": "Y",
                "resolverType": null,
                "_type": "RulePartOperand"
            },
            "combine": "OR",
            "subParts": [],
            "_type": "RulePart"
        }
    ]
}

我想从"left"检索与"Value"相关的数据:

value

当我使用以下(json_array_elements)时:

select json_array_elements(design::json -> 'design') 
from public.rule_definition where  definition_id = 'some id'

我有:

Elements

然而，我很难理解如何检索单个元素，IE，"值"字段.

正如你可能已经猜到的，我以前没有使用PostgreSQL，因此，我真的很感激你可能有任何见解，这将帮助我向前迈进. 谢谢大家