pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedFetch the required rows
2+ messages / 2 participants
[nested] [flat]
* Fetch the required rows
@ 2003-08-26 17:45 shyamperi@davlin.co.in
0 siblings, 1 reply; 2+ messages in thread
From: shyamperi@davlin.co.in @ 2003-08-26 17:45 UTC (permalink / raw)
To: pgsql-sql
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
Have a grate day
-----
Warm Regards
Shÿam Peri
II Floor, Punja Building,
M.G.Road,
Ballalbagh,
Mangalore-575003
Ph : 91-824-2451001/5
Fax : 91-824-2451050
DISCLAIMER: This message contains privileged and confidential information and is
intended only for the individual named.If you are not the intended
recipient you should not disseminate,distribute,store,print, copy or
deliver this message.Please notify the sender immediately by e-mail if
you have received this e-mail by mistake and delete this e-mail from
your system.
Attachments:
Untitled1 (text/html, 1007B) download
<head></head><body marginwidth=4 marginheight=4 topmargin=4 leftmargin=4><P><FONT face=verdana size=2>August 26th 2003<BR>11:30p<BR>How do I get the required number of rows thru a query..<BR>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<BR><BR>Have a grate day<BR></FONT></P><PRE>-----
<STRONG>Warm Regards
Shÿam Peri
</STRONG>
II Floor, Punja Building,
M.G.Road,
Ballalbagh,
Mangalore-575003
Ph : 91-824-2451001/5
Fax : 91-824-2451050
</PRE></body><br><br><b>
DISCLAIMER: This message contains privileged and confidential information and is
intended only for the individual named.If you are not the intended
recipient you should not disseminate,distribute,store,print, copy or
deliver this message.Please notify the sender immediately by e-mail if
you have received this e-mail by mistake and delete this e-mail from
your system.</b>
* Re: Fetch the required rows
@ 2003-08-26 18:13 Bruno Wolff III <bruno@wolff.to>
parent: shyamperi@davlin.co.in
0 siblings, 0 replies; 2+ messages in thread
From: Bruno Wolff III @ 2003-08-26 18:13 UTC (permalink / raw)
To: shyamperi@davlin.co.in; +Cc: pgsql-sql
On Tue, Aug 26, 2003 at 23:15:48 +0530,
shyamperi@davlin.co.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.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2003-08-26 18:13 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-08-26 17:45 Fetch the required rows shyamperi@davlin.co.in
2003-08-26 18:13 ` Bruno Wolff III <bruno@wolff.to>
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