Result set limits

From: "Tamayo, Damian-p65828" <Damian(dot)Tamayo(at)gdc4s(dot)com>
To: <pgsql-in-general(at)postgresql(dot)org>
Subject: Result set limits
Date: 2009-07-07 22:16:27
Message-ID: 2B0195B08BA41748A38C4D58ADF44F2C0385BF3C@AZ25EXM01.gddsi.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-in-general

Hi,
I'm new to postgreSQL and was wondering if there is a way to return only
a set of rows back to the user at a time? Does it need to be explicitly
Stated in the query? Or is it something that the jdbc driver takes care
of for you?
So an example:
Let's say that I want to return 50 rows at a time should there be more
than 50 returns from the query. How would I do the following?
1.) Check the number or rows being returned without having to pull the
entire set down... this would defeat the efficiency issue I'm looking to
avoid
2.) return 50 at a time from the last set that was returned...
Clarification: The set of 50 is an arbitrary number picked to represent
a size. This size in reality may be set by the user.
Any help with this would be greatly appreciated. Thanks in advance

My apologies for the misleading subject line. Should be corrected now.

Damian Tamayo
General Dynamics C4 Systems
Student Intern
BMSD
Collaborative Battle Management Systems Section
480-441-1346

This email message is for the sole use of the intended recipient(s) and
may contain GDC4S confidential or privileged information. Any
unauthorized review, use, disclosure is prohibited. If you are not an
intended recipient, please contact the sender by reply email and destroy
all copies of the original message.

Browse pgsql-in-general by date

  From Date Subject
Next Message Tamayo, Damian-p65828 2009-07-08 15:43:12 Unnest() and xml
Previous Message Tamayo, Damian-p65828 2009-07-07 22:12:28 Re: Xpath() return xml[]