David Johnston yahoo.com> writes:
>
> Trigve Siver wrote
> > I want to iterate all records with cursor from beginning to end. This
> > sample could be rewritten using FETCH FORWARD 1 ... without using MOVE but
> > I'm interested with solution which throws error.
>
> Is you interest purely acade
Trigve Siver wrote
> I want to iterate all records with cursor from beginning to end. This
> sample could be rewritten using FETCH FORWARD 1 ... without using MOVE but
> I'm interested with solution which throws error.
Is you interest purely academic or is there some reason you were evaluating
thi
>
> From: Giuseppe Broccolo
>To: pgsql-general@postgresql.org
>Sent: Wednesday, September 4, 2013 6:26 PM
>Subject: Re: [GENERAL] FETCH FORWARD 0 and "cursor can only scan forward"
>error
>
>
>
>Hi Trigve,
>
>Il 04
Trigve Siver 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".
regards, tom lane
--
Sent via pgs
> From: Tom Lane
> To: Trigve Siver
> Cc: "pgsql-general@postgresql.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 writes:
>> yes I
Hi Trigve,
Il 04/09/2013 15:06, Trigve Siver ha scritto:
Hi,
I'm on PostgreSQL 9.2.2 and trying to use no scroll cursor for some data fetch. But when
moving cursor ahead one record and the fetching the actual record the error "cursor
can only scan forward" is returned. I don't know if I'm doin
Hi,
I'm on PostgreSQL 9.2.2 and trying to use no scroll cursor for some data fetch.
But when moving cursor ahead one record and the fetching the actual record the
error "cursor can only scan forward" is returned. I don't know if I'm doing
something wrong but I don't think I'm going backward with