On Wednesday, August 30, 2017, Wei Shan <weishan(dot)ang(at)gmail(dot)com> wrote:
> 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.