Re: how to get the total number of records in report

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: AI Rumman <rummandba(at)gmail(dot)com>
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: how to get the total number of records in report
Date: 2010-10-28 18:18:26
Message-ID: AANLkTinB5-uW0U-uQ7PwYOtE2hg_PUaGAN8jUNbSToYn@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Thu, Oct 28, 2010 at 1:49 PM, AI Rumman <rummandba(at)gmail(dot)com> wrote:
> But I am using Postgresql 8.1 and it is not possible to write query as your
> one here.

with 8.1, you are limited to subquery approach, application derived
count, plpgsql hacks, etc.

merlin

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Ben 2010-10-28 18:44:41 Re: partitioning question 1
Previous Message AI Rumman 2010-10-28 17:49:25 Re: how to get the total number of records in report