> From: Tom Lane <tgl@xxxxxxxxxxxxx> > To: Trigve Siver <trigves@xxxxxxxxx> > Cc: "pgsql-general@xxxxxxxxxxxxxx" <pgsql-general@xxxxxxxxxxxxxx> > Sent: Wednesday, September 4, 2013 7:04 PM > Subject: Re: FETCH FORWARD 0 and "cursor can only scan forward" error > >T rigve Siver <trigves@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general