Triggers - need help !!!
От
Pradeepkumar, Pyatalo (IE10)
Тема
Triggers - need help !!!
Дата
Msg-id
77ED2BF75D59D1439F90412CC5B109740E88BEC1@ie10-sahara.hiso.honeywell.com
Список
Дерево обсуждения
Re: Triggers - need help !!! "Pradeepkumar, Pyatalo (IE10)" <Pradeepkumar.Pyatalo@honeywell.com>
Re: Triggers - need help !!! Richard Huxton <dev@archonet.com>
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;END IF; .......... 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 по дате отправления