[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-sql
Subject:    Re: [SQL] pagination problem in postgresql need help
From:       Emi Lu <emilu () encs ! concordia ! ca>
Date:       2011-06-20 13:29:25
Message-ID: 4DFF4B35.7040808 () encs ! concordia ! ca
[Download RAW message or body]

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



-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
[prev in list] [next in list] [prev in thread] [next in thread]