Re: Why does jsonb_set() remove non-mentioned keys?

On Thu, Jul 4, 2019 at 2:09 PM David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>
wrote:

> On Thursday, July 4, 2019, Gianni Ceccarelli <dakkar(at)thenautilus(dot)net>
> wrote:
>
>>
>> > select to_jsonb('null'::text);
>> ┌──────────┐
>> │ to_jsonb │
>> ├──────────┤
>> │ "null" │
>> └──────────┘
>>
>>
> Json null
>
>
Sorry, my bad on this last one. You cannot use to_jsonb to construct a
json null. The only way, I think, to construct a json null scalar is with
an explicit literal.

SELECT 'null'::jsonb;

The to_jsonb function always interprets a textual value passed to it as
being the literal text and so the original query results in a json string
whose content is "null"

David J.