Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id D4E6563229C
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Mon,  3 Aug 2009 06:19:03 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia,
	port 10024) with ESMTP id 88524-01 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Mon,  3 Aug 2009 09:18:53 +0000 (UTC)
Received: from news.hub.org (news.hub.org [200.46.204.72])
	by mail.postgresql.org (Postfix) with ESMTP id 89DC9632522
	for <pgsql-sql@postgresql.org>; Mon,  3 Aug 2009 06:18:53 -0300 (ADT)
Received: from news.hub.org (news.hub.org [200.46.204.72])
	by news.hub.org (8.14.3/8.14.3) with ESMTP id n739Inio007781
	for <pgsql-sql@postgresql.org>; Mon, 3 Aug 2009 06:18:49 -0300 (ADT)
	(envelope-from news@news.hub.org)
Received: (from news@localhost)
	by news.hub.org (8.14.3/8.14.3/Submit) id n7392uYR081874
	for pgsql-sql@postgresql.org; Mon, 3 Aug 2009 06:02:56 -0300 (ADT)
	(envelope-from news)
From: dino <dinesh.psql@gmail.com>
X-Newsgroups: pgsql.sql
Subject: Activity count problem
Date: Mon, 3 Aug 2009 02:02:59 -0700 (PDT)
Organization: http://groups.google.com
Lines: 12
Message-ID: 
 <6fc36e34-c0db-4476-87a7-2c05bbc32e2e@k19g2000yqn.googlegroups.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Complaints-To: groups-abuse@google.com
Complaints-To: groups-abuse@google.com
Injection-Info: k19g2000yqn.googlegroups.com; posting-host=216.113.168.130;
	posting-account=91797woAAAClQTImPB9QbT6ptFR83Jc2
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US;
 rv:1.9.0.12)
	Gecko/2009070611 Firefox/3.0.12 (.NET CLR 3.5.30729),
	gzip(gfe), gzip(gfe)
To: pgsql-sql@postgresql.org
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.001 tagged_above=-10 required=5 tests=BAYES_50=0.001
X-Spam-Level: 
X-Archive-Number: 200908/5
X-Sequence-Number: 32914

Hi All,

Is there a way I can get activity count of previously run sql to do
some quick error checks.
Say like I ran a select query on an error table and if the activity
count shows that the select query resulted in 10 rows, I want the
process to show failure status. Can this be tracked in pgsql?

Please help me out with this.

Thanks,
Dino