Re: Bug in move 0 - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Bug in move 0
Date
Msg-id 8010.960695229@sss.pgh.pa.us
Whole thread Raw
In response to RE: Bug in move 0  ("Hiroshi Inoue" <Inoue@tpf.co.jp>)
Responses Re: Bug in move 0  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-bugs
"Hiroshi Inoue" <Inoue@tpf.co.jp> 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).  MOVE is not in the spec but it seems it ought
to behave like that too.

The fix seemed too extensive to be making in the last days of 7.0
beta, so I let it go at the time --- but someone should fix this.

            regards, tom lane

pgsql-bugs by date:

Previous
From: "Hiroshi Inoue"
Date:
Subject: RE: Bug in move 0
Next
From: Bruce Momjian
Date:
Subject: Re: Bug in move 0