Обсуждение: Get the number of records of a result set

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.

Hello

http://www.postgresql.org/docs/8.2/interactive/plpgsql-statements.html#PLPGSQL-STATEMENTS-DIAGNOSTICS

regards
Pavel Stehule


On 30/01/2008, Eugenio Tacchini <eugenio.tacchini@elfo.net> 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(*).
>
> Thanks.
>
> Regards,
>
> Eugenio.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faq
>

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.

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.