On 10/26/2014 04:14 PM, Thom Brown wrote: On 26 October 2014 20:07, Andrew Dunstan <andrew@dunslane.net <mailto:andrew@dunslane.net>> wrote: On 10/26/2014 03:50 PM, Pavel Stehule wrote: Hi I have a question, what is expected result of null strip of {"a": {"b": null, "c", null"} } ? Please remember not to top-post. The above is not legal json, so the answer would be an error. I believe Pavel means: {"a": {"b": null, "c": null} } This is the expected result: andrew=# select json_strip_nulls('{"a": {"b": null, "c": null} }'); json_strip_nulls ------------------ {"a":{}} (1 row) It is NOT expected that we replace an empty object with NULL (and then strip it if it's a field value of an outer level object).
On 26 October 2014 20:07, Andrew Dunstan <andrew@dunslane.net <mailto:andrew@dunslane.net>> wrote: On 10/26/2014 03:50 PM, Pavel Stehule wrote: Hi I have a question, what is expected result of null strip of {"a": {"b": null, "c", null"} } ? Please remember not to top-post. The above is not legal json, so the answer would be an error. I believe Pavel means: {"a": {"b": null, "c": null} }
cheers andrew
pgsql-hackers by date:
Соглашаюсь с условиями обработки персональных данных