From: | Rainer Bauer <usenet(at)munnin(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Yet Another COUNT(*)...WHERE...question |
Date: | 2007-08-16 15:20:13 |
Message-ID: | 7cq8c3dar3u22at8i7siiqfigsm45dr52c@4ax.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Martijn van Oosterhout wrote:
>On Thu, Aug 16, 2007 at 01:09:32PM +0200, Rainer Bauer wrote:
>> Anyway, what Phoenix is trying to say is that 2 queries are required: One to
>> get the total count and one to get the tuples for the current page. I reckon
>> it would help, if the query returning the result set could also report the
>> total no. of tuples found. Somthing like
>> SELECT COUNT(*), * FROM <table> WHERE <cond> OFFSET <o> LIMIT <l>
>
>Well, thee is another possibility, use cursors:
>
>DECLARE CURSOR ... AS <query>;
>FETCH 30 -- or however many to want now
>MOVE TO END -- or whatever the command is, this gives you the number of rows
>
>Hope this helps,
Thanks! I will give this a try.
Rainer
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2007-08-16 15:20:30 | Re: how to get id of currently executed query? |
Previous Message | Rainer Bauer | 2007-08-16 15:20:09 | Re: Yet Another COUNT(*)...WHERE...question |