Would I gain any advantage by changing to it to fire after the insert?
thanks again for the help
Patrick Hatcher
Development Manager Analytics/MIO
Macys.com
415-422-1610
Doug McNaught
<doug@xxxxxxxxxxx
g> To
Patrick Hatcher
01/25/06 01:36 PM <PHatcher@xxxxxxxxx>
cc
pgsql-general@xxxxxxxxxxxxxx
Subject
Re: [GENERAL] Trigger question:
ROW or STATEMENT?
Patrick Hatcher <PHatcher@xxxxxxxxx> writes:
> Here is the trigger the way it is currently written. I add some
additional
> information from another table:
If you're modifying each row before it goes in, it should definitely
be a FOR EACH ROW trigger.
-Doug
