> On 15 November 2017 at 22:54, RODRIGUEZ CORTES MARIO IGNACIO < ignacio.cor...@inegi.org.mx> 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?