On Mon, Sep 8, 2025 at 3:37 AM PALAYRET Jacques
wrote:
> 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_a
Cc: [email protected]
Envoyé: Vendredi 5 Septembre 2025 18:21:08
Objet: Re: PostgreSQL include directive in plpgsql language PL/pgSQL
On Fri, Sep 5, 2025 at 7:14 AM PALAYRET Jacques < [
mailto:[email protected] | [email protected] ] > wrote:
Hello,
In
On Mon, Sep 8, 2025 at 5:37 AM PALAYRET Jacques
wrote:
> I can manage with this method, but it shoud be better with a include
> directive.
>
Even if we had includes, I would strongly advise "this method" which seems
pretty clean and maintainable. What is the issue with SQL functions that
call a
On Fri, Sep 5, 2025 at 9:14 AM PALAYRET Jacques
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 oth
On Fri, Sep 5, 2025 at 7:14 AM PALAYRET Jacques
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 oth
"David G. Johnston" writes:
> On Friday, September 5, 2025, PALAYRET Jacques
> wrote:
>> Is there an equivalent of #include (include directive) in functions
>> (written in plpgsql language)?
> No, there is not.
And there won't be one in the future either, as it would
give server filesystem acce
On Friday, September 5, 2025, PALAYRET Jacques
wrote:
>
>
> Is there an equivalent of #include (include directive) in functions
> (written in plpgsql language)?
>
No, there is not.
David J.
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 others textual.
It would not be
