Re: strip nulls functions for json and jsonb

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).

cheers

andrew