Re: select count(*) and limit - Mailing list pgsql-novice

From Verena Ruff
Subject Re: select count(*) and limit
Date
Msg-id 446C65FF.5030907@triosolutions.at
Whole thread Raw
In response to Re: select count(*) and limit  (Oscar Rodriguez Fonseca <info@vraniscci.com>)
Responses Re: select count(*) and limit
List 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 by date:

Previous
From: Oscar Rodriguez Fonseca
Date:
Subject: Re: select count(*) and limit
Next
From: Verena Ruff
Date:
Subject: Re: select count(*) and limit