Re: Proposition fetch cursors - Mailing list pgsql-general

From Craig Ringer
Subject Re: Proposition fetch cursors
Date
Msg-id 4DF758EC.1010607@postnewspapers.com.au
Whole thread Raw
In response to Proposition fetch cursors  (Radosław Smogura <rsmogura@softperience.eu>)
Responses Re: Proposition fetch cursors
List pgsql-general
On 06/14/2011 04:30 PM, Radosław Smogura wrote:
> Hello,
>
> I have proposition about one missing feature for cursors. Actually there
> is no support for fetching some data from cursor without moving it (in
> context of external applications). This could be nice if driver could
> fetch e.g. 100 rows, buffer it internally and then move cursor at
> desired position in order to update data. I think this is known approach
> in databases.

Interesting.

Do you want this only for scrollable cursors? Or do you want/need to be
able to "peek" ahead into the results of a non-scrollable cursor too?

What's your use case?

--
Craig Ringer

pgsql-general by date:

Previous
From: "Albe Laurenz"
Date:
Subject: Re: duplicate key violate error
Next
From: Craig Ringer
Date:
Subject: Re: how to install plpython?