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.
tia Mike