Postgres Pro
Downloads
Home   >   mailing lists

Re: pagination problem in postgresql need help - Mailing list pgsql-sql

From Emi Lu
Subject Re: pagination problem in postgresql need help
Date
Msg-id 4DFF4B35.7040808@encs.concordia.ca
Whole thread Raw
In response to Re: pagination problem in postgresql need help  (Jasen Betts <jasen@xnet.co.nz>)
List pgsql-sql
Tree view 
>> select aiah_number.aiah_number_id, aiah_number.aiah_number,
> ...
>> order by rank_value desc limit 1 offset 1;

I use:
==================  select ...  order by ...  LIMIT #{pageSize}::INTEGER OFFSET #{offset}::INTEGER;

Emi

pgsql-sql by date:

Previous
From: Jasen Betts
Date:
Subject: Re: pagination problem in postgresql need help
Next
From: Cstdenis
Date:
Subject: Query to select nested comments sorted by nesting and date