| From: | Fabrízio de Royes Mello <fabrizio(at)timbira(dot)com(dot)br> |
|---|---|
| To: | Steven Lembark <lembark(at)wrkhors(dot)com> |
| Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: execute block like Firebird does |
| Date: | 2018-02-11 16:23:29 |
| Message-ID: | CAPfkCSCGP+fJSp4S7iEJ=5WduWKGKSOLpANpF_J-Mp-v7hCnuQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Em dom, 11 de fev de 2018 às 13:54, Steven Lembark <lembark(at)wrkhors(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thiemo Kellner | 2018-02-11 16:41:43 | Re: execute block like Firebird does |
| Previous Message | Steven Lembark | 2018-02-11 15:52:41 | Re: execute block like Firebird does |