create function my_fun () returns opaque as ' declare -- vars here; begin -- code here; end;' language 'plpgsql'; create trigger my_trigger after insert on my_table for each row execute procedure my_fun ();
So, slowly I'm getting this.... Based on this, it looks like I need to revise my function. What I need to understand is how column values are passed. In my working function above, They were passed to the function.
What I want this trigger to do, is to get two column values from bboard after any insert and then insert or update these two values into my helper table.