On Mon, Jun 18, 2007 at 06:07:37PM -0700, novnov wrote:
> First, when a record is being deleted, OLD refers to the rec just deleted
> (or about to be deleted)?
Correct.
> Second, while I could write two trigger functions, one dealing with
> add/update, the other with deletes, it's probably neater to have a single
> trigger function and have it discriminate "am I being called for a delete,
> or an add/update?" I don't know how to determine the type record change.
In PL/pgSQL you can use TG_OP. See "Trigger Procedures" in the
documentation:
http://www.postgresql.org/docs/8.2/interactive/plpgsql-trigger.html
--
Michael Fuhr
