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@yahoo.com



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