Re: syntax question - Mailing list pgsql-general

From Bruce Momjian
Subject Re: syntax question
Date
Msg-id 20210603190108.GC22019@momjian.us
Whole thread Raw
In response to syntax question  (Marc Millas <marc.millas@mokadb.com>)
Responses Re: syntax question  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
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.

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  If only the physical world exists, free will is an illusion.




pgsql-general by date:

Previous
From: Marc Millas
Date:
Subject: syntax question
Next
From: Adrian Klaver
Date:
Subject: Re: syntax question