Re: FETCH FORWARD 0 and "cursor can only scan forward" error

> From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>

> To: Trigve Siver <trigves(at)yahoo(dot)com>
> Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
> Sent: Wednesday, September 4, 2013 7:04 PM
> Subject: Re: [GENERAL] FETCH FORWARD 0 and "cursor can only scan forward" error
>
>T rigve Siver <trigves(at)yahoo(dot)com> writes:
>> yes I know that when specifying "FORWARD 0" that no move is done
> and
>> actual record is returned. But my question is why it is forbidden by
> "NO
>> SCROLL"?
>
> Because it's implemented as "back up 1 row and re-fetch".

Thanks,
So I'll try to emulate it somehow then.
 
>             regards, tom lane
>

Trigve