Stupid question really,If I have to specify the entire JSON value, this means that the update query replaces the entire row instead of updating a single field. Is this correct?
The whole row is always replaced. Any values not specified in the update set list are simply copied over to the new record as-is.
David J.
