Postgres Pro
Downloads
Home   >   mailing lists

Re: [ADMIN] Some questions on PostgreSQL 9.6 JSONB - Mailing list pgsql-admin

From David G. Johnston
Subject Re: [ADMIN] Some questions on PostgreSQL 9.6 JSONB
Date
Msg-id CAKFQuwb1-hkSiSokxe9bR-keoo5_f-iMdjORXyRHZ=yJo+=kiA@mail.gmail.com
Whole thread Raw
In response to Re: [ADMIN] Some questions on PostgreSQL 9.6 JSONB  (Wei Shan <weishan.ang@gmail.com>)
List pgsql-admin
Tree view
On Wednesday, August 30, 2017, Wei Shan <weishan.ang@gmail.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. 

pgsql-admin by date:

Previous
From: Wei Shan
Date:
Subject: Re: [ADMIN] Some questions on PostgreSQL 9.6 JSONB
Next
From: Mariel Cherkassky
Date:
Subject: [ADMIN] Fwd: printing results of query to file in different times