Trigger function that works with both updates and deletes?

From: novnov <novnovice(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Trigger function that works with both updates and deletes?
Date: 2007-06-19 01:07:37
Message-ID: 11186941.post@talk.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Most of the trigger fuctions I've written work on new and updated records
referencing NEW. etc. I will need some of the trigger functions to work with
record deletions too.

First, when a record is being deleted, OLD refers to the rec just deleted
(or about to be deleted)?

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.
--
View this message in context: http://www.nabble.com/Trigger-function-that-works-with-both-updates-and-deletes--tf3943732.html#a11186941
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2007-06-19 01:36:59 Re: Trigger function that works with both updates and deletes?
Previous Message Michael Glaesemann 2007-06-18 22:02:31 Re: statistics monitoring performance improvment -- 8.1 as well as 8.2 ?