Re: move 0 behaviour

Peter Eisentraut <peter_e@gmx.net>

From: Peter Eisentraut <peter_e@gmx.net>
To: Bruce Momjian <pgman@candle.pha.pa.us>
Cc: Dave Cramer <dave@fastcrypt.com>, "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>
Date: 2002-10-30T18:32:12Z
Lists: pgsql-hackers, pgsql-general
Bruce Momjian writes:

> So, that is why MOVE 0 goes to the end of the cursor.  One idea would be
> for MOVE 0 to actually move nothing, but jdbc and others need the
> ability to move the end of the cursor, perhaps to then back up a certain
> amount and read from there.  Seems MOVE 0 is the logical way to do that.
> (I can't think of another reasonable value).

It would seem more logical and reasonable for MOVE 0 to do nothing and
have some special syntax such as MOVE LAST to move to the end.  (MOVE LAST
would actually be consistent with the standard syntax FETCH LAST.)

-- 
Peter Eisentraut   peter_e@gmx.net