Em dom, 11 de fev de 2018 às 13:54, Steven Lembark <lembark@xxxxxxxxxxx> escreveu:
> > you can use a DO - block:
> >
> >
> > https://www.postgresql.org/docs/current/static/sql-do.html
> >
>
> But DO blocks returns "void", I mean you can't return values/records
> from this statement.
Insert the necessary records into a temporary table, process them,
post-process them into variables or destination table?
Can be a solution, but it can lead to a catalog bloat.
Regards,
--
Fabrízio de Royes Mello Timbira - http://www.timbira.com.br/
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento