<washingtonirving(at)yahoo(dot)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