Search Postgresql Archives

Re: Get the number of records of a result set

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux