Dear Postgres Community,
cf. https://www.postgresql.org/docs/current/sql-update.html :
As far as I understand, I can
* UPDATE myTable SET col1 = val1, col2 = val2, ...
* UPDATE myTable SET (col1, col2, ...) = <ROW-or-subselect>
But I cannot, and I am missing that:
* UPDATE myTable SET (myTable.*) = <ROW-or-subselect>
* UPDATE myTable SET (col1, col2, ...) = json_populate_record(NULL::myTable, myJson) -- this is a function, not a ROW construct and not a subselect
This would be useful for some of my trigger code.
Regards,
fjf2002