I want to UPDATE a table but I will not know until run time which columns will be updated. I would like to do something like this:
update mytest t (SELECT * FROM json_populate_record(null::mytest,'{"key":22,"header":44,"ident":66,"static01":"this","static02":"that"}'));
In other words, I will be receiving a json document on an input parameter. The columns named in the json document can be a sub set of those that exist in the table.