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

From Edson Carlos Ericksson Richter
Subject Re: execute block like Firebird does
Date
Msg-id d2eec140-e145-6d68-89ac-242db9a79838@simkorp.com.br
Whole thread Raw
In response to execute block like Firebird does  (PegoraroF10 <marcos@f10.com.br>)
List pgsql-general
Em 11/02/2018 03:57, PegoraroF10 escreveu:
> We are migrating our databases from Firebird to PostGres. A useful feature
> Firebird has is Execute Block.
> What it does is just return a record set from that dynamic SQL, just like a
> PostGres function, but without creating it.
> It sound like ...
> execute block returns(ID Integer, Name varchar(50), LastInvoice Date, ...)
> as
> begin
>    select bla, bla, bla into ...;
>    select bla, bla into ...;
>    suspend;
> end
> I know we could create a function but we have several hundred of these
> blocks running, so ... it would be a huge work to do.
> So, there is a way to run a dynamic sql which returns a set of records ?

Can't you use "with ... select ..."?

Like:

with qry1 as (select bla, bla, bla from xyz), qry2 as (select bla, bla 
from ...)
select * from qry1
union all
select * from qry2


?

Regards,

Edson

-- 
> Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
>
>



pgsql-general by date:

Previous
From: Konstantin Evteev
Date:
Subject: Using standby for read-only queries in production and DML operationson primary.
Next
From: Venkateswaran
Date:
Subject: Re: Split read/write queries between 2 servers (one master and oneslave with streaming replication)?