Re: Proposition fetch cursors

From: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
To: Radosław Smogura <rsmogura(at)softperience(dot)eu>
Cc: Pgsql general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Proposition fetch cursors
Date: 2011-06-14 12:49:48
Message-ID: 4DF758EC.1010607@postnewspapers.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Craig Ringer 2011-06-14 12:50:40 Re: how to install plpython?
Previous Message Albe Laurenz 2011-06-14 12:35:04 Re: duplicate key violate error