MIME-Version: 1.0
References: <1985501673.206991527.1757078030654.JavaMail.zimbra@meteo.fr>
In-Reply-To: <1985501673.206991527.1757078030654.JavaMail.zimbra@meteo.fr>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Fri, 5 Sep 2025 12:36:05 -0400
Message-ID: <CANzqJaDiiu9Qy7e=TsLqqU9KCJSXWJQngoS5cVX2up4b-P7Bkw@mail.gmail.com>
Subject: Re: PostgreSQL include directive in plpgsql language PL/pgSQL
To: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000d01f5b063e106fcc"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaDiiu9Qy7e%3DTsLqqU9KCJSXWJQngoS5cVX2up4b-P7Bkw%40mail.gmail.com>
Precedence: bulk

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

On Fri, Sep 5, 2025 at 9: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.
>

What about something like a "parent" function which a bunch of "stub"
functions call?  The stub functions would have different parameter types,
know what to call the parent function with, and how to return the correct
number value.

Because of name overloading, they might even have the same name.

--=20
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

--000000000000d01f5b063e106fcc
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 9: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_-3767204190919702657zimbraEditorContainer" 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></div></div></div></blockquote><div><br></di=
v><div>What about something like a &quot;parent&quot; function which a bunc=
h of &quot;stub&quot; functions call?=C2=A0 The stub functions would have d=
ifferent parameter types, know what to call the parent function with, and h=
ow to return the correct number value.</div><div><br></div><div>Because of =
name overloading, they might even have the same name.</div><div><br></div><=
/div><span class=3D"gmail_signature_prefix">-- </span><br><div dir=3D"ltr" =
class=3D"gmail_signature"><div dir=3D"ltr">Death to &lt;Redacted&gt;, and b=
utter sauce.<div>Don&#39;t boil me, I&#39;m still alive.<br><div><div>&lt;R=
edacted&gt; lobster!</div></div></div></div></div></div>

--000000000000d01f5b063e106fcc--