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 dest
Hello,
I'm writing a function in PL/pgSQL and I would like to know if there
is a method to get the number of records in a result set, after a
select query, without executing the same query using COUNT(*).
Thanks.
Regards,
Eugenio.
---(end of broadcast)--
