Content-Type: text/plain;
	charset=utf-8
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3776.700.51.11.1\))
Subject: Re: Trying to dynamically create a procedure
From: Christophe Pettus <xof@thebuild.com>
In-Reply-To: <CH0PR03MB6034C83799B64677E3D4941AFAA62@CH0PR03MB6034.namprd03.prod.outlook.com>
Date: Wed, 26 Mar 2025 13:30:02 -0700
Cc: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Transfer-Encoding: quoted-printable
Message-Id: <7BD4DF66-9D95-4B56-A91E-1BD08599B5D6@thebuild.com>
References: <CALdEsqOM2q7bXt1Bo2S_41nHgSjR2_epzm=aHHFoHsQdzB3fqQ@mail.gmail.com>
 <CH0PR03MB6034C83799B64677E3D4941AFAA62@CH0PR03MB6034.namprd03.prod.outlook.com>
To: "Dirschel, Steve" <steve.dirschel@thomsonreuters.com>
Archived-At: <https://www.postgresql.org/message-id/7BD4DF66-9D95-4B56-A91E-1BD08599B5D6%40thebuild.com>
Precedence: bulk


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

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.=