Re: move 0 behaviour - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: move 0 behaviour
Date
Msg-id Pine.LNX.4.44.0210301928450.2006-100000@localhost.localdomain
Whole thread Raw
In response to Re: move 0 behaviour  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: move 0 behaviour
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Larry Rosenman
Date:
Subject: Re: 7.3b3 ok on unixware 71[12] here
Next
From: Peter Eisentraut
Date:
Subject: Re: [CYGWIN] Request for supported platforms