Way to use count() and LIMIT? - Mailing list pgsql-general

From Joe Koenig
Subject Way to use count() and LIMIT?
Date
Msg-id 3C1F8511.B9FFB772@jwebmedia.com
Whole thread Raw
Responses Re: Way to use count() and LIMIT?
List pgsql-general
Is there a way to structure a query so you can only run 1 query, get the
full number of rows that would be returned, but then use LIMIT to step
through in groups of 20? For example, a search in my CD's/Rock section
will return 53,000 results. I want to give the user the number of total
results, but also use LIMIT to go through 20 at a time? Does this
require 2 queries? Thanks,

Joe

pgsql-general by date:

Previous
From: "Andrew Snow"
Date:
Subject: Re: PG sql string -> time_t
Next
From: Jason Earl
Date:
Subject: Re: Way to use count() and LIMIT?