update without SET ? - Mailing list pgsql-sql

From Michael Moore
Subject update without SET ?
Date
Msg-id CACpWLjNc9G3hZfkVViveirXRaLThzmah185xvsSPQxf8J+sX9A@mail.gmail.com
Whole thread Raw
Responses Re: update without SET ?  (Hector Vass <hector.vass@metametrics.co.uk>)
Re: update without SET ?  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-sql
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

pgsql-sql by date:

Previous
From: Jürgen Purtz
Date:
Subject: Replication
Next
From: Hector Vass
Date:
Subject: Re: update without SET ?