On Sunday 04 April 2004 20:40, Peter Erickson wrote:
Ok, I have determined that i can't do: IF NEW IS NOT NULL -- or -- IF OLD IS NOT NULL and that is what is causing the error.
So, with this now known, is there a way to create a trigger & function that will allow inserts, updates, and deletes to occur while updating a field (mtime) in another table? At the same time, if an update takes place, it updates the modified time field (mtime) to the current time.
I can them all to work individually by modifying the function, but I cant get the to all work in the same function. Do I need to create a trigger for inserts/updates and another for deletes?
In plpgsql, there are a number of special TG_XXX variables defined. You want to look at TG_OP. See the manuals for details.
Thanks. Worked like a charm. I must have glossed over the variables other than NEW and OLD.
Thanks again.
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
