From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Bruce Momjian <bruce(at)momjian(dot)us>, Marc Millas <marc(dot)millas(at)mokadb(dot)com> |
Cc: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: syntax question |
Date: | 2021-06-03 19:11:00 |
Message-ID: | c58b04ac-e713-f089-8400-763a742bf86d@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 6/3/21 12:01 PM, Bruce Momjian wrote:
> On Thu, Jun 3, 2021 at 08:58:03PM +0200, Marc Millas wrote:
>> Hi,
>>
>> within a function, I want to create another function.
>> no pb.
>> but if I write:
>> declare bidule text;
>> begin
>> bidule:='myfunc';
>> create function bidule() ...
>>
>>
>> it does create a function named bidule and not myfunc.
>> so I am obviously missing something too obvious.
>
> You can't create functions inside of functions; same for procedures.
>
Sure you can:
CREATE OR REPLACE FUNCTION public.test_fnc()
RETURNS void
LANGUAGE plpgsql
AS $function$
DECLARE
bidule text;
BEGIN
bidule:='myfunc';
EXECUTE 'create function ' || bidule || '() RETURNS void language
plpgsql AS $fnc$ BEGIN END; $fnc$ ';
END;
$function$
select test_fnc();
test_fnc
----------
\df myfunc
List of functions
Schema | Name | Result data type | Argument data types | Type
--------+--------+------------------+---------------------+------
public | myfunc | void | | func
Whether you should is another question.
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2021-06-03 19:21:15 | Re: syntax question |
Previous Message | Bruce Momjian | 2021-06-03 19:01:08 | Re: syntax question |