Re: execute block like Firebird does

[Fabrízio de Royes Mello <fabrizio@xxxxxxxxxxxxxx>]

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