On Mon, May 22, 2006 at 10:41:59AM -0500, Jim C. Nasby wrote: > > CREATE TRIGGER name { BEFORE | AFTER } { event [ OR ... ] } > > ON table FOR EACH STATEMENT > > EXECUTE PROCEDURE funcname ( arguments ) > > And that doesn't give you any information on the rows that were > modified. Other RDBMSes will provide a NEW rowset and an OLD rowset that > you can select from inside the trigger as if they were real tables.
Is this on the TODO list? It doesn't seem too difficult to create a tuplestore and store the NEW and OLD tuples there and pass the whole set to the trigger. Have a nice day, -- Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to > litigate.
signature.asc
Description: Digital signature