Delete values from JSON - Mailing list pgsql-general

Hi, in PG-14, how do I delete the keys "dunsNumber": "NaN":

{  "sessionId": "ce6fc9d0-5923-4d71-9f7e-ae60f35c45d6",  "details": [    {      "keyInformation": {        "dunsNumber": "NaN",        "organizationType": "LIMITED_COMPANY"      }    },    {      "keyInformation": {        "dunsNumber": "123",        "organizationType": "LIMITED_COMPANY"      }    }  ],  "nisse": 123
}

So that the result becomes:

{  "sessionId": "ce6fc9d0-5923-4d71-9f7e-ae60f35c45d6",  "details": [    {      "keyInformation": {        "organizationType": "LIMITED_COMPANY"      }    },    {      "keyInformation": {        "dunsNumber": "123",        "organizationType": "LIMITED_COMPANY"      }    }  ],  "nisse": 123
}

Thanks.

--

Andreas Joseph Krogh

CTO / Partner - Visena AS

Mobile: +47 909 56 963

andreas@visena.com

www.visena.com