Re: [GENERAL] How to insert/update a bunch of JSOB values?

On Mon, Jul 11, 2016 at 8:45 AM, Deven Phillips wrote: > We need to update a JSONB data structure in our tables to include an > 'is_valid' flag. I was able to build a CTE which I use to create a temp > table containing the 'is_valid' value, the path where it needs to be

[GENERAL] How to insert/update a bunch of JSOB values?

We need to update a JSONB data structure in our tables to include an 'is_valid' flag. I was able to build a CTE which I use to create a temp table containing the 'is_valid' value, the path where it needs to be set, and the join criteria. Let's say that the temp table looks like: id TEXT, >