From: | Chris <dmagick(at)gmail(dot)com> |
---|---|
To: | Michael Fuhr <mike(at)fuhr(dot)org> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: count and limit |
Date: | 2006-08-18 00:53:26 |
Message-ID: | 44E50F86.3010700@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Michael Fuhr wrote:
> On Fri, Aug 18, 2006 at 10:34:44AM +1000, Chris wrote:
>> Fabio Victora Hecht wrote:
>>> I was wondering if there's a way to count the results of a query and
>>> return part of the result set it in one query (LIMIT). Because I usually
>>> have to count the results using one query (to tell the user how many
>>> records match the criteria) and show the first 20 records.
>> I was going to suggest a cursor but I don't think you can get the number
>> of results a cursor has :(
>
> You can but you have to MOVE to the end, so the backend has to visit
> each tuple just as it would for COUNT. I answered a similar question
> recently:
>
> http://archives.postgresql.org/pgsql-novice/2006-07/msg00220.php
>
Thanks for the pointer :)
I do a lot of those type of things too so this may be a way to handle it
better.
--
Postgresql & php tutorials
http://www.designmagick.com/
From | Date | Subject | |
---|---|---|---|
Next Message | Jasbinder Bali | 2006-08-18 01:19:37 | Re: [NOVICE] DB insert Error |
Previous Message | Chris | 2006-08-18 00:52:32 | Re: count and limit |