Re: Bug in move 0

Bruce Momjian <pgman@candle.pha.pa.us> writes:
> I just sent off an email stating that MOVE 0 goes to the end, and that
> the FETCH manual page says:

>               Postgres does not currently support this notion; in
>               fact the value zero is reserved  to  indicate  that
>               all  rows  should be retrieved and is equivalent to
>               ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
>               specifying the ALL keyword.  If the  RELATIVE  key-
>               word  has  been used, the Postgres assumes that the
>               user intended SQL92 behavior and returns this error
>               message.

> So it seems we are OK.

We may have documented the behavior, but that doesn't make it right ;-)
If someone were to submit a patch to change MOVE 0 into a no-op
(without breaking MOVE ALL of course), I'd vote to apply it.

            regards, tom lane