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. -- Richard Huxton Archonet Ltd ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
