Re: cursor bug - Mailing list pgsql-general

From Tom Lane
Subject Re: cursor bug
Date
Msg-id 3296.1062280948@sss.pgh.pa.us
Whole thread Raw
In response to cursor bug  (<washingtonirving@yahoo.com>)
Responses Re: cursor bug  (<washingtonirving@yahoo.com>)
List pgsql-general
<washingtonirving@yahoo.com> writes:
> Under some cases, using cursors and the fetch and move commands don't
> work as expected.

Moving backwards in complex queries (anything more complex than a single
table scan) doesn't work reliably in releases before 7.4.  In 7.4 you
can do it, but you'll usually have to specifically declare the cursor
as SCROLL ... and eat the ensuing overhead ...

            regards, tom lane

pgsql-general by date:

Previous
From:
Date:
Subject: cursor bug
Next
From:
Date:
Subject: Re: cursor bug