On Sat, Aug 28, 2021 at 7:04 AM Roger Mason <rmason@mun.ca> wrote:
get_final_energy (NEW.jid);
If you want to use this function within a trigger it should be redefined to accept "NEW" (i.e., the table record itself), not the jid column (IOW, don't perform a select on the table during the middle of the trigger execution).