Re: syntax question

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: 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:01:08
Message-ID: 20210603190108.GC22019@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)momjian(dot)us> https://momjian.us
EDB https://enterprisedb.com

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2021-06-03 19:11:00 Re: syntax question
Previous Message Marc Millas 2021-06-03 18:58:03 syntax question