Search Postgresql Archives

Re: count and limit

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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/


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux