title: How to update an empty jsonb column using jsonb_set in postgresql?
body: <p>My purpose is to update a <code>jsonb</code> column using <code>jsonb_set</code>, which is currently null, with an object having more than one key-value pairs. The update command executes successfully but it is not updating anything, the column is still coming up empty. I am trying the following query. </p>
  
  <pre><code>UPDATE tab 
    set value = jsonb_set(value, '{}', '{"a" : 100, "b" : [100, 200]}'::jsonb) 
  where id = 100;
  </code></pre>
  
  <p>Any solutions ?</p>