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 ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
