Re: Get the number of records of a result set - Mailing list pgsql-general

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.