Re: Trying to dynamically create a procedure - Mailing list pgsql-general

From Christophe Pettus
Subject Re: Trying to dynamically create a procedure
Date
Msg-id 7BD4DF66-9D95-4B56-A91E-1BD08599B5D6@thebuild.com
Whole thread Raw
In response to Trying to dynamically create a procedure  ("Dirschel, Steve" <steve.dirschel@thomsonreuters.com>)
List pgsql-general

> On Mar 26, 2025, at 13:27, Dirschel, Steve <steve.dirschel@thomsonreuters.com> wrote:
>
>   I think the problem has to do with having AS $$ and END $$ with the 2 $’s.

PostgreSQL's multiline-string syntax is quite flexible.  You can do things like:

DO $doblock$
 ...
$doblock$
LANGUAGE plpgsql;

I tend to put the name of the function between the $s to avoid nesting problems.


pgsql-general by date:

Previous
From: "Dirschel, Steve"
Date:
Subject: Trying to dynamically create a procedure
Next
From: Tom Lane
Date:
Subject: Re: Q on SELECT column list pushdown from view to table