MIME-Version: 1.0
References: <1985501673.206991527.1757078030654.JavaMail.zimbra@meteo.fr>
In-Reply-To: <1985501673.206991527.1757078030654.JavaMail.zimbra@meteo.fr>
From: Merlin Moncure <mmoncure@gmail.com>
Date: Fri, 5 Sep 2025 10:21:08 -0600
Message-ID: <CAHyXU0zNE3CuPs2433GZtVh9SbrkyTUwGmAiy+yJuhz484gPUw@mail.gmail.com>
Subject: Re: PostgreSQL include directive in plpgsql language PL/pgSQL
To: PALAYRET Jacques <jacques.palayret@meteo.fr>
Cc: pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="00000000000068a6b9063e103a61"
Archived-At: <https://www.postgresql.org/message-id/CAHyXU0zNE3CuPs2433GZtVh9SbrkyTUwGmAiy%2ByJuhz484gPUw%40mail.gmail.com>
Precedence: bulk

--00000000000068a6b9063e103a61
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Fri, Sep 5, 2025 at 7:14=E2=80=AFAM PALAYRET Jacques <jacques.palayret@m=
eteo.fr>
wrote:

> Hello,
>
> In a PL/pgSQL function, there is no command for sharing a common part of
> the body of several functions, is there?
>
> In my case, I would like a function that returns a numeric value; this
> value is associated with several other parameters, some numeric and other=
s
> textual.
> It would not be practical for maintenance to have several functions (one
> function for each given parameter) with much of the code being identical.
>
> Presently, I have a text function with all the parameters in return and a
> function for each parameter based on the first one (with all the
> parameters), using substr(), position(), etc.
> For me, I think it would be easier (and perhaps faster) to use some kind
> of #include in the body of all the functions.
>

 Can you provide some examples of what you are trying to accomplish?

There may be some workarounds using immutable functions other tricks, but
I'm not 100% sure I have my head around your issue.

merlin

--00000000000068a6b9063e103a61
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Fri, Sep 5, 2025 at 7:14=E2=80=AFAM PA=
LAYRET Jacques &lt;<a href=3D"mailto:jacques.palayret@meteo.fr">jacques.pal=
ayret@meteo.fr</a>&gt; wrote:</div><div class=3D"gmail_quote gmail_quote_co=
ntainer"><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8e=
x;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div><div id=3D"=
m_-1810555428013026615zimbraEditorContainer" style=3D"font-family:garamond,=
&quot;new york&quot;,times,serif;font-size:12pt;color:rgb(0,0,0)"><div>Hell=
o,<br><br>In a PL/pgSQL function, there is no command for sharing a common =
part of the body of several functions, is there?<br><br>In my case, I would=
 like a function that returns a numeric value; this value is associated wit=
h several other parameters, some numeric and others textual.<br>It would no=
t be practical for maintenance to have several functions (one function for =
each given parameter) with much of the code being identical.<br><br>Present=
ly, I have a text function with all the parameters in return and a function=
 for each parameter based on the first one (with all the parameters), using=
 substr(), position(), etc.<br>For me, I think it would be easier (and perh=
aps faster) to use some kind of #include in the body of all the functions.<=
/div></div></div></blockquote><div><br></div><div>=C2=A0Can you provide som=
e examples of what you are trying to=C2=A0accomplish?</div><div><br></div><=
div>There may be some workarounds using immutable functions other tricks, b=
ut I&#39;m not 100% sure I have my head around your issue.</div><div><br></=
div><div>merlin</div></div></div>

--00000000000068a6b9063e103a61--