Re: pagination problem in postgresql need help

From: Emi Lu <emilu(at)encs(dot)concordia(dot)ca>
To: Jasen Betts <jasen(at)xnet(dot)co(dot)nz>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: pagination problem in postgresql need help
Date: 2011-06-20 13:29:25
Message-ID: 4DFF4B35.7040808@encs.concordia.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

>> 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Cstdenis 2011-06-20 15:04:47 Query to select nested comments sorted by nesting and date
Previous Message Jasen Betts 2011-06-19 08:37:13 Re: pagination problem in postgresql need help