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
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
Hello
http://www.postgresql.org/docs/8.2/interactive/plpgsql-statements.html#PLPGSQL-STATEMENTS-DIAGNOSTICS
regards
Pavel Stehule
On 30/01/2008, Eugenio Tacchini <[EMAIL PROTECTED]> wrote:
> Hello,
> I'm writing a function in PL/pgSQL and I would like to know if there
> is a method to get the n
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)--