Re: Delete values from JSON

Excellent! Thanks! På lørdag 18. mars 2023 kl. 14:26:57, skrev Boris Zentner mailto:b...@2bz.de>>: Am 17.03.2023 um 08:56 schrieb Andreas Joseph Krogh : Hi, in PG-14, how do I delete the keys "dunsNumber": "NaN": { "sessionId": "ce6fc9d0-5923-4d71-9f7e-ae60f35c45d6", "details": [ {

Re: Delete values from JSON

> Am 17.03.2023 um 08:56 schrieb Andreas Joseph Krogh : > > Hi, in PG-14, how do I delete the keys "dunsNumber": "NaN": > > { > "sessionId": "ce6fc9d0-5923-4d71-9f7e-ae60f35c45d6", > "details": [ > { > "keyInformation": { > "dunsNumber": "NaN", >

Re: Delete values from JSON

På fredag 17. mars 2023 kl. 11:56:22, skrev Romain MAZIÈRE < romain.mazi...@sigmaz-consilium.fr >: Hi, If it is jsonb type, you can have a look at the documentation : https://www.postgresql.org/docs/14/functions-json.html

Re: Delete values from JSON

Hi, If it is jsonb type, you can have a look at the documentation : https://www.postgresql.org/docs/14/functions-json.html There are some examples : |jsonb| |-| |text| → |jsonb| Deletes a key (and its value) from a JSON object, or matching string value(s) from a JSON array. |'{"a": "b",

Delete values from JSON

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":