Re: [ADMIN] Some questions on PostgreSQL 9.6 JSONB
| От | Wei Shan |
|---|---|
| Тема | Re: [ADMIN] Some questions on PostgreSQL 9.6 JSONB |
| Дата | |
| Msg-id | CAFe9ZTr2_cPQ80AmRRvHmjoX3BgEV8KSYyBcpMUSBZqbvucFOg@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: [ADMIN] Some questions on PostgreSQL 9.6 JSONB ("David G. Johnston" <david.g.johnston@gmail.com>) |
| Ответы |
Re: [ADMIN] Some questions on PostgreSQL 9.6 JSONB
|
| Список | pgsql-admin |
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?
On 28 August 2017 at 16:20, David G. Johnston <david.g.johnston@gmail.com> wrote:
On Mon, Aug 28, 2017 at 9:46 AM, Wei Shan <weishan.ang@gmail.com> wrote:Is this the most efficient way to do it? I'm not sure because this is basically replacing the entire JSON object instead of updating a single field.
keith@keith=# UPDATE json_data SET data = jsonb_set(data, '{account_balance}', '1'::jsonb, false);This. Note still that in a MVCC (multi-version concurrency controlling) database you never really just update something in place since the old something has to continue to exist at the same time as the new something - at least for a little while.David J.
Regards,
Ang Wei Shan
Ang Wei Shan
В списке pgsql-admin по дате отправления: