[GENERAL] trigger sub-functions

[Thomas F. O'Connell]

is there any way to get access to the new and old records created by a 
trigger in the function it calls?

i.e., if i have

create trigger after_insert after insert on foo
execute procedure trigger_after_insert_foo();

is there any way to do something like the following...

create function trigger_after_insert_foo() returns opaque as '
begin
        /*
         * have some function like sub_foo() that accesses new and               * 
returns it 
somehow.
         */
        return new;
end
' language 'plpgsql';

-tfo


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly