Store select query as variable and loop for entire variable

Question

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 $$

You don't need a loop or PL/pgSQL for this.

user330315
– user330315

2021-03-17 07:56:16 +00:00
Commented Mar 17, 2021 at 7:56 — user330315
– user330315, Commented Mar 17, 2021 at 7:56

Gordon Linoff · Accepted Answer · 2021-03-17 13:12:51Z

1

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.

answered Mar 17, 2021 at 13:12

Gordon Linoff

1.3m62 gold badges705 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Store select query as variable and loop for entire variable

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related