Re: select count(*) and limit

Поиск
Список
Период
Сортировка
От Verena Ruff
Тема Re: select count(*) and limit
Дата
Msg-id 446C65FF.5030907@triosolutions.at
обсуждение исходный текст
Ответ на Re: select count(*) and limit  (Oscar Rodriguez Fonseca <info@vraniscci.com>)
Ответы Re: select count(*) and limit  (Oscar Rodriguez Fonseca <info@vraniscci.com>)
Список pgsql-novice
Oscar Rodriguez Fonseca schrieb:
> But I do not get the point of the query.
>
the reason why I'm asking is that I have some rather complex queries and
I'd like to present the result in a paged way. I need to get the 10
records I'd like to present the user and I need to know how many records
there are to calculate how many pages are needed and to create the
neccessary links. The real query isn't as simple as the shown example,
there are a few joins making it quite complex and slow. So I'm looking
for a way to do this with one query and saving some time.

Regards,
Verena

В списке pgsql-novice по дате отправления:

Предыдущее
От: Oscar Rodriguez Fonseca
Дата:
Сообщение: Re: select count(*) and limit
Следующее
От: Verena Ruff
Дата:
Сообщение: Re: select count(*) and limit