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 <[EMAIL PROTECTED] g> To Patrick Hatcher 01/25/06 01:36 PM <[EMAIL PROTECTED]> cc pgsql-general@postgresql.org Subject Re: [GENERAL] Trigger question: ROW or STATEMENT? Patrick Hatcher <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org