Triggers - need help !!!
От | Pradeepkumar, Pyatalo (IE10) |
---|---|
Тема | Triggers - need help !!! |
Дата | |
Msg-id | 77ED2BF75D59D1439F90412CC5B109740E88BEC1@ie10-sahara.hiso.honeywell.com обсуждение исходный текст |
Ответы |
Re: Triggers - need help !!!
|
Список | pgsql-sql |
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.... CREATE FUNCTION ..... BEGINIF UPDATE(CreateTime) THEN SELECT INTO ValidCount COUNT(*) FROM PointTable WHERE NEW.PointId = PointTable.PointId;ENDIF; .......... END ; ' LANGUAGE 'plpgsql'; My question is how will refer to the row being deleted in the trigger function.\ I want to do something like this DELETE PointTable FROM PointTable WHERE PointTable.PointId = DELETED.PointId; Pls help me with this. > With Best Regards > Pradeep Kumar P J >
В списке pgsql-sql по дате отправления: