Re: Options for protocol level cursors - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Options for protocol level cursors
Date
Msg-id 15533.1213311559@sss.pgh.pa.us
Whole thread Raw
In response to Re: Options for protocol level cursors  (James William Pye <pgsql@jwp.name>)
Responses Re: Options for protocol level cursors
List pgsql-hackers
James William Pye <pgsql@jwp.name> writes:
> On Jun 12, 2008, at 10:08 AM, Tom Lane wrote:
>> James William Pye <pgsql@jwp.name> writes:
>>> Is there anyway to bind a cursor with SCROLL and WITH HOLD at the
>>> protocol level?
>> 
>> No, and for at least the first of those I don't see the point,
>> since the protocol doesn't offer any behavior other than forward
>> fetch.

> That protocol level inability doesn't keep you from using MOVE on  
> cursor's name.

Sure, but if you're willing to use a SQL-level operation on the portal
then you could perfectly well declare the cursor at SQL level too.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Decibel!
Date:
Subject: Re: Overhauling GUCS
Next
From: Andrew Dunstan
Date:
Subject: Re: b64_encode and decode