Re: Call a Normal function inside a Trigger Function

2023-04-16 Thread FOUTE K . Jaurès
Thanks @Adrian Klaver It's clear for me now. On Sun, 16 Apr 2023, 20:13 Adrian Klaver, wrote: > On 4/16/23 11:47, FOUTE K. Jaurès wrote: > > Can I have an example please? Or a link > > create table trg_test (id integer, fld_1 varchar, fld_2 boolean); > > > CREATE OR REPLACE FUNCTION public.chil

Re: Call a Normal function inside a Trigger Function

2023-04-16 Thread Pavel Stehule
Hi ne 16. 4. 2023 v 20:47 odesílatel FOUTE K. Jaurès napsal: > Can I have an example please? Or a link > > On Sun, 16 Apr 2023, 17:08 Pavel Stehule, wrote: > >> Hi >> >> >> ne 16. 4. 2023 v 16:15 odesílatel FOUTE K. Jaurès >> napsal: >> >>> Hello, >>> >>> Is it possible to call a function ins

Re: Call a Normal function inside a Trigger Function

2023-04-16 Thread Adrian Klaver
On 4/16/23 11:47, FOUTE K. Jaurès wrote: Can I have an example please? Or a link create table trg_test (id integer, fld_1 varchar, fld_2 boolean); CREATE OR REPLACE FUNCTION public.child_fnc(token character varying) RETURNS void LANGUAGE plpgsql AS $function$ BEGIN IF token = 'y

Re: Call a Normal function inside a Trigger Function

2023-04-16 Thread FOUTE K . Jaurès
Can I have an example please? Or a link On Sun, 16 Apr 2023, 17:08 Pavel Stehule, wrote: > Hi > > > ne 16. 4. 2023 v 16:15 odesílatel FOUTE K. Jaurès > napsal: > >> Hello, >> >> Is it possible to call a function inside a trigger function ? >> Any idea or link are welcome. Thanks in advance >> >

Re: Call a Normal function inside a Trigger Function

2023-04-16 Thread Pavel Stehule
Hi ne 16. 4. 2023 v 16:15 odesílatel FOUTE K. Jaurès napsal: > Hello, > > Is it possible to call a function inside a trigger function ? > Any idea or link are welcome. Thanks in advance > sure, there is not any limit. Regards Pavel > > Best Regards > -- > Jaurès FOUTE >

Re: Call a Normal function inside a Trigger Function

2023-04-16 Thread Erik Wienhold
> On 16/04/2023 16:18 CEST FOUTE K. Jaurès wrote: > > Is it possible to call a function inside a trigger function ? > Any idea or link are welcome. Thanks in advance Depends on what you want to do with the return value. Use PERFORM to ignore the result. [0] Use SELECT INTO to handle a single-ro

Call a Normal function inside a Trigger Function

2023-04-16 Thread FOUTE K . Jaurès
Hello, Is it possible to call a function inside a trigger function ? Any idea or link are welcome. Thanks in advance Best Regards -- Jaurès FOUTE