On Wed, 2008-01-30 at 09:14 +0100, Eugenio Tacchini wrote:
> 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(*).
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.
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
