Way to use count() and LIMIT?

Поиск
Список
Период
Сортировка
От Joe Koenig
Тема Way to use count() and LIMIT?
Дата
Msg-id 3C1F8511.B9FFB772@jwebmedia.com
обсуждение исходный текст
Ответы Re: Way to use count() and LIMIT?  (Jason Earl <jason.earl@simplot.com>)
Список 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 по дате отправления:

Предыдущее
От: "Andrew Snow"
Дата:
Сообщение: Re: PG sql string -> time_t
Следующее
От: Jason Earl
Дата:
Сообщение: Re: Way to use count() and LIMIT?