Date: Fri, 5 Sep 2025 13:13:50 +0000 (GMT)
From: PALAYRET Jacques <jacques.palayret@meteo.fr>
To: pgsql-general@lists.postgresql.org
Message-ID: <1985501673.206991527.1757078030654.JavaMail.zimbra@meteo.fr>
Subject: PostgreSQL include directive in plpgsql language  PL/pgSQL
MIME-Version: 1.0
Content-Type: multipart/alternative; 
	boundary="=_27d375a0-08fe-4c8c-971e-bea59b39dbad"
Thread-Index: ITWoMjlG0cq7Y46hVWTQDUO2a6wugQ==
Thread-Topic: PostgreSQL include directive in plpgsql language PL/pgSQL
Archived-At: <https://www.postgresql.org/message-id/1985501673.206991527.1757078030654.JavaMail.zimbra%40meteo.fr>
Precedence: bulk

--=_27d375a0-08fe-4c8c-971e-bea59b39dbad
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable

Hello,=20

In a PL/pgSQL function, there is no command for sharing a common part of th=
e body of several functions, is there?=20

In my case, I would like a function that returns a numeric value; this valu=
e is associated with several other parameters, some numeric and others text=
ual.=20
It would not be practical for maintenance to have several functions (one fu=
nction for each given parameter) with much of the code being identical.=20

Presently, I have a text function with all the parameters in return and a f=
unction for each parameter based on the first one (with all the parameters)=
, using substr(), position(), etc.=20
For me, I think it would be easier (and perhaps faster) to use some kind of=
 #include in the body of all the functions.=20

Is there an equivalent of #include (include directive) in functions (writte=
n in plpgsql language)?=20

Regards=20
----- M=C3=A9t=C3=A9o-France -----=20
PALAYRET Jacques=20

--=_27d375a0-08fe-4c8c-971e-bea59b39dbad
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: quoted-printable

<html><body><div id=3D"zimbraEditorContainer" style=3D"font-family: garamon=
d, new york, times, serif; font-size: 12pt; color: #000000" class=3D"2"><di=
v>Hello,<br><br>In a PL/pgSQL function, there is no command for sharing a c=
ommon 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 associat=
ed with several other parameters, some numeric and others textual.<br>It wo=
uld not be practical for maintenance to have several functions (one functio=
n for each given parameter) with much of the code being identical.<br><br>P=
resently, I have a text function with all the parameters in return and a fu=
nction 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 (an=
d perhaps faster) to use some kind of #include in the body of all the funct=
ions.<br><br>Is there an equivalent of #include (include directive) in func=
tions (written in plpgsql language)?<br><br>Regards</div><div data-marker=
=3D"__SIG_PRE__">----- M=C3=A9t=C3=A9o-France -----<br>PALAYRET Jacques<br>=
</div></div></body></html>
--=_27d375a0-08fe-4c8c-971e-bea59b39dbad--