Hi,
I am writing some triggers for my project. I am writing a trigger on a table after delete....I want to know how u refer to the row that is being deleted.
For example for a trigger function after INSERT/UPDATE u refer to the row being inserted/updated using NEW like this....
Use OLD instead of NEW.
You can also use OLD inside UPDATE triggers - you have access to row before update.
Regards, Tomasz Myrta
---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
