Re: PostgreSQL include directive in plpgsql language PL/pgSQL

Hello,

Thanks for your response.

# Currently, I have a function text and a function array with the same body but a distinct type return.
-> Example with the array of text function :
SELECT public.calfxi3s_all_elements_text_array(12345678, '2025-01-01 00:00') ;
                    calfxi3s_all_elements_text_array
-------------------------------------------------------------------------
 {3.2,sonic,"Capteur Vent ultrasonique compact Brand xxx",2,-0.123,0.321}
That gives some parameters : the value of the wind strength (3.2), the kind of sensor (sonic), the model (Capteur ...), the environmment (2), two coefficients (-0.123,0.321)

Then I have several functions using the previous one, for example public.calfxi3s_value() :

CREATE OR REPLACE FUNCTION public.calfxi3s_value(np integer, dt timestamp without time zone)
 RETURNS numeric
 LANGUAGE sql
 STABLE
AS $function$
SELECT (public.calfxi3s_all_elements_text_array(np,dt))[1]::numeric ;
$function$

I can manage with this method, but it shoud be better with a include directive.

Now, it doesn't exist. so I will do in an other way

A+