Re: execute block like Firebird does - Mailing list pgsql-general

From Fabrízio de Royes Mello
Subject Re: execute block like Firebird does
Date
Msg-id CAPfkCSCGP+fJSp4S7iEJ=5WduWKGKSOLpANpF_J-Mp-v7hCnuQ@mail.gmail.com
Whole thread Raw
In response to Re: execute block like Firebird does  (Steven Lembark <lembark@wrkhors.com>)
List pgsql-general

Em dom, 11 de fev de 2018 às 13:54, Steven Lembark <lembark@wrkhors.com> 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

pgsql-general by date:

Previous
From: Steven Lembark
Date:
Subject: Re: execute block like Firebird does
Next
From: Thiemo Kellner
Date:
Subject: Re: execute block like Firebird does