Re: Get the number of records of a result set

From: Eugenio Tacchini <eugenio(dot)tacchini(at)elfo(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Get the number of records of a result set
Date: 2008-01-30 08:59:41
Message-ID: 20080130085942.068AA68873@smtp.eutelia.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Markus Schiltknecht 2008-01-30 09:49:14 Re: how to create cluster(loadbanacing) of postgresql server
Previous Message Håkan Jacobsson 2008-01-30 08:52:17 Re: Getting the count(*) from two tables and two date ranges in same query