Re: insert trigger

Yes Roberto ,
Trigger are very relaible and are fired in intutive manner.

(trigger is fired for every insert )

read documentation of create trigger

regds
mallah.

regds
mallah.

> I have the following situation:
>
> when a new record is inserted in to a psql table, i want to be able to update certain
> fields. the way i'm doing it right now..to find the last record inserted...is by sorting
> the primary key (serial) in descending order and taking the first item in the list...the one
> at the top should be the one i just entered...and of course, i then procede to update the
> fieldsd i need to update..
> So, basically would like to know if this will always work. will the one at the top (the one w/
> the highest primary key [serial type]) always be the one i just entered. AND does psql ALWAYS
> execute the trigger(s) after EVERY single record that is inerted. what would happen if [ n ]
> different users try to insert records simultaniously? will psql insert one-execute the trigger,
> insert the next-execute the trigger..and so on? or will it insert ALL [n] records AND THEN
> execute the trigger?
>
> i would appreciate any advice--if this would work, or if there is a better way.
>
> thanks
> rbenitez22(at)yahoo(dot)com

-----------------------------------------
Get your free web based email at trade-india.com.
"India's Leading B2B eMarketplace.!"
http://www.trade-india.com/