At 16.35 30/01/2008 +0800, Ow Mun Heng wrote: >not sure what exactly you mean, but perhaps this could help? > > del_stime := timeofday(); > execute del_qry; > del_etime := timeofday(); > > GET DIAGNOSTICS del_rows = ROW_COUNT; > >This would get you the # of rows inserted into the destination table >etc. This is exactly what I mean, thanks a lot to you and Pavel. Eugenio. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster