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

From Adrian Klaver
Subject Re: execute block like Firebird does
Date
Msg-id 45ecb017-06af-ed3c-dfdc-be32ce0df924@aklaver.com
Whole thread Raw
In response to Re: execute block like Firebird does  (PegoraroF10 <marcos@f10.com.br>)
Responses Re: execute block like Firebird does
List pgsql-general
On 02/12/2018 08:57 AM, PegoraroF10 wrote:
> I know I need to think a different approach of what execute blocks does on
> Firebird.
> What I was trying to was just let them the way they were wrote, because
> their results are correct and with more time replace them to a new way.

That may not be necessary. As someone mentioned upstream you maybe able 
to replace the EXECUTE BLOCK with CREATE OR REPLACE FUNCTION and then do 
some clean up/additions to the enclosed code. To be more certain about 
this we would need to see a complete example of one of EXECUTE BLOCKs. 
If that is possible for security reasons, then a made example that does 
the same thing.

> 
> But, if that way cannot be used, I´ll probably write some hundred of
> functions right now and use them, because this way works for sure. And then,
> with more time to spend, I´ll replace them one by one.

Why? Once you create the functions and they do the task what is the 
purpose of replicating them and more to the point how would you?

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


-- 
Adrian Klaver
adrian.klaver@aklaver.com


pgsql-general by date:

Previous
From: PegoraroF10
Date:
Subject: Re: execute block like Firebird does
Next
From: Steve Atkins
Date:
Subject: Re: persistent read cache