Ok, I took Don's suggestion and looked at some .sql code
in oacs4.5. It appears that all functions used in
triggers pass no variables and "returns opaque" is used
to indicate this. Example:
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.
Hints appreciated!
-Bob
