I want to store the result of select query from another table and set it as variable. Then i want to loop through the variable and use it in my loop for. The question is how i can store the result of select query from my table?
do $$ declare ids <data_type> := <SELECT DISTINCT (*) from a>; begin for id in ids loop insert into b ( select from c where c.id in id end loop; end $$
Advertisement
Answer
Why not run a single query?
insert into b ( . . . )
select . . .
from c
where c.id in (select id from a);
The . . . are for listing the columns/expressions for the insert.