Re: Web + Slicing/Paging datas - Mailing list pgsql-general

From Jasen Betts
Subject Re: Web + Slicing/Paging datas
Date
Msg-id gt6sbv$kao$2@reversiblemaps.ath.cx
Whole thread Raw
In response to Web + Slicing/Paging datas  (durumdara <durumdara@gmail.com>)
List pgsql-general
On 2009-04-23, durumdara <durumdara@gmail.com> wrote:
> Hi!
>
> In a mod_py application I wanna write a wrapper that handle all PSQL
> data view with paging/slicing.
>
> For example:
> I have 1.500 records. I wanna show only N (f. ex: 15) records in the
> view, other records are accessable with a pager (links):

For small numbers of records you can use


SELECT ...
... LIMIT how_many OFFSET where_to_start


If there are a large number of results this may be inefficient.


pgsql-general by date:

Previous
From: Jasen Betts
Date:
Subject: Re: Sequence Incrementing by 2 insted of 1
Next
From: Developer
Date:
Subject: postgres only in local socket