Seems MOVE 0 moves to the end of the cursor. The FETCH manual says:
SQL92 allows one to repetatively retrieve the cur-
sor at its "current position" using the syntax
FETCH RELATIVE 0 FROM cursor
Postgres does not currently support thi
> "Hiroshi Inoue" <[EMAIL PROTECTED]> writes:
> > If I remember correctly *move 0* means *move all* in the
> > implementation of cursor.
>
> It does (I looked at it before).
>
> > I don't know if it's the spec or not.
>
> As best I can tell from SQL92, FETCH RELATIVE 0 implies no movement
> (r
> Bruce Momjian <[EMAIL PROTECTED]> 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
> >
Bruce Momjian <[EMAIL PROTECTED]> writes:
>> 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.
> If we do that, how does one move to the end of
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> >> 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.
>
> > If we do that, how does one move to
Bruce Momjian <[EMAIL PROTECTED]> 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
>
"Hiroshi Inoue" <[EMAIL PROTECTED]> writes:
> If I remember correctly *move 0* means *move all* in the
> implementation of cursor.
It does (I looked at it before).
> I don't know if it's the spec or not.
As best I can tell from SQL92, FETCH RELATIVE 0 implies no movement
(refetch same row). M
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Bruce Momjian
>
> I can confirm this bug still exists in the code. Sorry.
>
> >
> > Please enter a FULL description of your problem:
> >
> >
> > If
I can confirm this bug still exists in the code. Sorry.
> =
> POSTGRESQL BUG REPORT TEMPLATE
> =
>
>
> Your name :
