trigger sub-functions - Mailing list pgsql-general

From Thomas F. O'Connell
Subject trigger sub-functions
Date
Msg-id 3AFAD9D5.4070006@monsterlabs.com
Whole thread Raw
List pgsql-general
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


pgsql-general by date:

Previous
From: newsreader@mediaone.net
Date:
Subject: very odd behavior
Next
From: Fran Fabrizio
Date:
Subject: Trigger only firing once