Hi David, finally got a chance to look at this. I don't see how the SO example applies to my case. Basically what I am doing is trying to simulate a SQL UPDATE statement. currently I am doing this, and
it works, but it is slow, so I am looking for a better way.
[In reality there are about 40 columns and up to 600 rows ]
select jsonb_agg(row_to_json(alias)) from
(select
question_seq,
case select_type when 'EDUPROGRAM' then -10 else prompt_seq end as prompt_seq,
jsonb_populate_recordset(null::ypxportal2__fgetquestions,j_final_rslt) rt)alias into j_final_rslt;
The SQL equiv of this would be:
Update mytable, set prompt_seq = -10 where select_type = 'EDUPROGRAM'