Re: Updating jsonb rows

On Fri, Aug 11, 2017 at 6:08 PM, Michael Moore <michaeljmoore(at)gmail(dot)com>
wrote:

> ​s​
> elect jsonb_set(j_final_rslt, '{0,prompt_seq}','99',true) into
> j_final_rslt;
>
> gives the result:
> BEFORE [{"prompt_seq": *150*, "attribute_name": "InsuredTimeframe"},
> {"prompt_seq": 1200, "attribute_name": "DriverOccupation"}]
>
> AFTER [{"prompt_seq": *99*, "attribute_name": "InsuredTimeframe"},
> {"prompt_seq": 1200, "attribute_name": "DriverOccupation"}]
>
> How could I change this to ALSO change the attribute_name on the 2nd
> record to "ABC". The AFTER result would ideally look like:
>
>
​This SO post seems like it should get you close. Basically you pull out
the 0th element, concatenate in the values you want to change, and supply
that result as the third jsonb_set argument.

https://stackoverflow.com/questions/38883233/postgres-jsonb-set-multiple-keys-update

David J.