Re: Fetch the required rows

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: shyamperi(at)davlin(dot)co(dot)in
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Fetch the required rows
Date: 2003-08-26 18:13:39
Message-ID: 20030826181339.GC17741@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Tue, Aug 26, 2003 at 23:15:48 +0530,
shyamperi(at)davlin(dot)co(dot)in wrote:
> August 26th 2003
> 11:30p
> How do I get the required number of rows thru a query..
> I mean...If I want to show 10 tuples per page.. instead of getting all the tuples from the relation and do some front end manipulation, is there any way by which I can get only 10 required tuples from the relation

You can use limit and offset to do this.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message shyamperi 2003-08-26 18:44:31 regarding the same in db2 - fetch tuples
Previous Message shyamperi 2003-08-26 17:45:48 Fetch the required rows