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 по дате отправления
От: Bruce Momjian
Дата:
От: Tomasz Myrta
Дата:
Сообщение: Re: Triggers - need help !!!
FAQ