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 -- Michael Fuhr ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
