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

From James William Pye
Subject Re: Options for protocol level cursors
Date
Msg-id 142CED17-AEFE-4002-BC62-58D107E29589@jwp.name
Whole thread Raw
In response to Re: Options for protocol level cursors  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Options for protocol level cursors  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
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.
And yes, it yield the appropriate errors when you try to MOVE  
backwards on a protocol declared cursor.


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Options for protocol level cursors
Next
From: Gregory Stark
Date:
Subject: Re: Overhauling GUCS