Skip site navigation (1) Skip section navigation (2)

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 (view raw, whole thread or download thread mbox)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group