Re: JSONB in-place updates? - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: JSONB in-place updates?
Date
Msg-id 534C4225.6020600@agliodbs.com
Whole thread Raw
In response to JSONB in-place updates?  (kelas <kelaskin@gmail.com>)
Responses Re: JSONB in-place updates?  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-hackers
On 04/14/2014 09:27 AM, kelas wrote:
> Are there any plans to add "in-place at-depth" update operator for JSONB
> type, e.g.:
> 
> UPDATE test SET attrs->'anwser' = 42 where attrs->'answer' = 41
> 

Plans, yes.  But not until 9.5, or maybe as an extension.

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com



pgsql-hackers by date:

Previous
From: kelas
Date:
Subject: JSONB in-place updates?
Next
From: Tom Lane
Date:
Subject: Re: Custom Scan APIs (Re: Custom Plan node)