pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Emi Lu <emilu@encs.concordia.ca>
To: Jasen Betts <jasen@xnet.co.nz>
Cc: pgsql-sql@postgresql.org
Subject: Re: pagination problem in postgresql need help
Date: Mon, 20 Jun 2011 09:29:25 -0400
Message-ID: <4DFF4B35.7040808@encs.concordia.ca> (raw)
In-Reply-To: <itkcfp$d3t$1@reversiblemaps.ath.cx>
References: <4DFBD8A0.9000503@softpro.bz>
	<itkcfp$d3t$1@reversiblemaps.ath.cx>

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

view thread (3+ messages)

Message-ID: <4DFF4B35.7040808@encs.concordia.ca>
Permalink:  ../4DFF4B35.7040808@encs.concordia.ca/
Also on:    postgresql.org/message-id/4DFF4B35.7040808@encs.concordia.ca

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: emilu@encs.concordia.ca, jasen@xnet.co.nz
  Subject: Re: pagination problem in postgresql need help
  In-Reply-To: <4DFF4B35.7040808@encs.concordia.ca>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox