Re: Inline PL/pgSQL

David,

I agree with your idea.  That seems like it would be somewhat easy to 
implement and would do exactly what I would need.  Anyone else have 
ideas or thoughts along this line?

David Fetter wrote:

>On Mon, May 09, 2005 at 11:44:23AM -0600, Jonah H. Harris wrote:
>  
>
>>Hey everyone,
>>
>>In addition to package support in plpgsql, it would be really handy
>>to have inline plpgsql.  Likewise, I think there are others who feel
>>this way as-well.
>>    
>>
>
>Why yes, there are. :)
>
>  
>
>>Years ago, Oracle merged PL/SQL with their normal SQL parser which
>>allowed for inline PL/SQL.  They did this because it was difficult
>>to maintain two separate parsers.  While this worked great for
>>Oracle, it probably wouldn't really work as well for PostgreSQL
>>because pgsql supports multiple procedural languages.
>>    
>>
>
>I proposed a syntax for this awhile back.  I haven't found it in the
>archives, but it goes like this:
>
>EXECUTE IMMEDIATE $$
>    function body here
>$$
>LANGUAGE plfoo;
>
>Similarly, a CREATE TEMPORARY FUNCTION could be quite handy.
>
>Cheers,
>D
>  
>