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

From Steven Lembark
Subject Re: execute block like Firebird does
Date
Msg-id 20180211095241.494f60ac@wrkhors.com
Whole thread Raw
In response to Re: execute block like Firebird does  (Fabrízio de Royes Mello <fabrizio@timbira.com.br>)
Responses Re: execute block like Firebird does  (Fabrízio de Royes Mello <fabrizio@timbira.com.br>)
List pgsql-general
> > 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?

-- 
Steven Lembark                                       1505 National Ave
Workhorse Computing                                 Rockford, IL 61103
lembark@wrkhors.com                                    +1 888 359 3508


pgsql-general by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: execute block like Firebird does
Next
From: Fabrízio de Royes Mello
Date:
Subject: Re: execute block like Firebird does