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

Reply via email to