Posts by Raphael Andres • 1 point
2 posts
-
0
votes1
answer49
viewsA: Postgresql - use custom select return in loop
I was able to solve it this way: FOR nome, email IN (SELECT a.nome, b.email into nome, email FROM tabela1 a INNER JOIN tabela2 b ON b.fk = a.fk) LOOP -- faz alguma coisa com as variáveis nome e…
-
0
votes1
answer49
viewsQ: Postgresql - use custom select return in loop
I have a function that makes a select like that: SELECT a.nome, b.email into nome, email FROM tabela1 a INNER JOIN tabela2 b ON b.fk = a.fk Is there any way to create a "temporary table" that I can…