> On 16/04/2023 16:18 CEST FOUTE K. Jaurès <jauresfoute@xxxxxxxxx> 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-row result. [1] PERFORM myfunc(); SELECT myfunc() INTO myresult; [0] https://www.postgresql.org/docs/current/plpgsql-statements.html#PLPGSQL-STATEMENTS-GENERAL-SQL [1] https://www.postgresql.org/docs/current/plpgsql-statements.html#PLPGSQL-STATEMENTS-SQL-ONEROW -- Erik
