Skip site navigation (1) Skip section navigation (2)

Re: Bug in move 0

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp>
Cc: "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us>, jutso(at)tpts5(dot)seed(dot)net(dot)tw, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Bug in move 0
Date: 2000-06-11 03:47:09
Message-ID: 8010.960695229@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
"Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)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

In response to

Responses

pgsql-bugs by date

Next:From: Bruce MomjianDate: 2000-06-11 03:47:11
Subject: Re: Bug in move 0
Previous:From: Hiroshi InoueDate: 2000-06-10 15:29:35
Subject: RE: Bug in move 0

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group