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.