how to get the total number of records in report

From: AI Rumman <rummandba(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: how to get the total number of records in report
Date: 2010-10-18 05:16:11
Message-ID: AANLkTimLXyfHRzo+PdrXmcMf_JKJL+L_EegusSeh1T-v@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

At present for reporting I use following types of query:
select crm.*, crm_cnt.cnt
from crm,
(select count(*) as cnt from crm) crm_cnt;
Here count query is used to find the total number of records.
Same FROM clause is copied in both the part of the query.
Is there any other good alternative way to get this similar value?

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Samuel Gendler 2010-10-18 06:13:01 Re: No hash join across partitioned tables?
Previous Message Merlin Moncure 2010-10-16 19:54:14 Re: Stored procedure declared as VOLATILE => no good optimization is done