Hi, I am looking for an efficient way to implement a "sliding window" view of the data from a query. I am developing a simple website and would like to provide for viewing(fetching) only a predetermined maximum number of records per page. For example to view 100 records with "30" as the predetermined maximum number of records to be fetched for any page, will require 3 page displays with 30 records then a fourth page display having only 10 records. A probable solution would be to use an order by clause on unique field(s) in the query (and the LIMIT <predetermined_max_number_of_records> clause), then store the these unique field(s) of the first and last records records in the web application (maybe sent it to the client embedded in the request response somehow). Then reuse these values for the next query by placing them in the where clause with a greater than or less than comparison operator (use the or operator in the case where of a composite unique key). Then use the order by and limit as usual. The above solution may be limited to only subsequent page views (prev or next) but will not work for page skips. Allan. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
