good reading, thanks Marc MILLAS Senior Architect +33607850334 www.mokadb.com
On Thu, Jun 3, 2021 at 9:21 PM Tom Lane <t...@sss.pgh.pa.us> wrote: > Adrian Klaver <adrian.kla...@aklaver.com> writes: > > On 6/3/21 12:01 PM, Bruce Momjian wrote: > >> On Thu, Jun 3, 2021 at 08:58:03PM +0200, Marc Millas wrote: > >>> within a function, I want to create another function. > > >> You can't create functions inside of functions; same for procedures. > > > Sure you can: > > Yeah. The actual problem here is that Marc is expecting variable > substitution to occur within a utility (DDL) statement, which it > doesn't. The workaround is to build the command as a string and > use EXECUTE, as Adrian illustrated: > > > EXECUTE 'create function ' || bidule || '() RETURNS void language > > plpgsql AS $fnc$ BEGIN END; $fnc$ '; > > This is not terribly well explained in the existing docs. I tried > to improve the explanation awhile ago in HEAD: > > > https://www.postgresql.org/docs/devel/plpgsql-statements.html#PLPGSQL-STATEMENTS-GENERAL-SQL > > regards, tom lane >
