Re: problem changing jsonb attribute to null value

[Dmitry Dolgov <9erthalion6@xxxxxxxxx>]

> On 15 November 2017 at 22:54, RODRIGUEZ CORTES MARIO IGNACIO <IGNACIO.CORTES@xxxxxxxxxxxx> wrote:
>
> I have a problem with a record in a jsonb type table, I'm trying to
> change the value of an attribute to null but it leaves me all the
> content in null and not just the value
>
> prueba=# select jsonb_set('{"v" : 0}'::jsonb, '{"v"}', to_jsonb(null));
> ERROR:  no se pudo determinar el tipo polimórfico porque el tipo de
> entrada es «unknown»
>
> defining null value as a text type:
>
> prueba=# select jsonb_set('{"v" : 0}'::jsonb, '{"v"}',
> to_jsonb(null::text));
>  jsonb_set
> -----------
>  
> (1 fila)
>
> it leaves the record in null, when I hope it leaves it with the null
> value in attribute "v": {"v": null}

I think something like this should work:

=# select jsonb_set('{"v" : 0}'::jsonb, '{"v"}', 'null'::jsonb);

  jsonb_set

-------------

 {"v": null}

(1 row)

is that what you want?