Re: Options for protocol level cursors

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: James William Pye <pgsql(at)jwp(dot)name>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Options for protocol level cursors
Date: 2008-06-12 22:59:19
Message-ID: 15533.1213311559@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

James William Pye <pgsql(at)jwp(dot)name> writes:
> On Jun 12, 2008, at 10:08 AM, Tom Lane wrote:
>> James William Pye <pgsql(at)jwp(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2008-06-12 23:07:01 Re: b64_encode and decode
Previous Message Decibel! 2008-06-12 22:18:46 Re: Overhauling GUCS