Skip site navigation (1) Skip section navigation (2)

Re: Xpath() return xml[]

From: "Tamayo, Damian-p65828" <Damian(dot)Tamayo(at)gdc4s(dot)com>
To: <pgsql-in-general(at)postgresql(dot)org>
Subject: Re: Xpath() return xml[]
Date: 2009-07-07 22:12:28
Message-ID: 2B0195B08BA41748A38C4D58ADF44F2C0385BF21@AZ25EXM01.gddsi.com (view raw or flat)
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. 


> Damian Tamayo
> General Dynamics C4 Systems
> 
> 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.
> 

pgsql-in-general by date

Next:From: Tamayo, Damian-p65828Date: 2009-07-07 22:16:27
Subject: Result set limits
Previous:From: Tamayo, Damian-p65828Date: 2009-07-01 17:25:06
Subject: Xpath() return xml[]

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group