Thread: FETCH/MOVE problem

Hi!

  I've a problem in 6.5.3 which might be a bug (if not in pg, at least
in my head)...

--------------------------------------------------
tiago=> declare c1 cursor for select * from treta;
SELECT
tiago=> fetch 1 in c1;
ola|adeus
---+-----
  1|bubu
(1 row)

tiago=> move backward all in c1;
MOVE
tiago=> fetch 1 in c1;
ola|adeus
---+-----
(0 rows)
---------------------------------------------------

Shouldn't fetch return, in the 2nd run, the same thing as in the
first???
Compare it with the following result:

---------------------------------------------------
tiago=> declare c1 cursor for select * from treta;
SELECT
tiago=> move backward all in c1;
MOVE
tiago=> fetch 1 in c1;
ola|adeus
---+-----
  1|bubu
(1 row)
----------------------------------------------------

Is it a bug in my head or in pg6.5.3?

Best regards,
Tiago

> -----Original Message-----
> From: owner-pgsql-general@postgreSQL.org
> [mailto:owner-pgsql-general@postgreSQL.org]On Behalf Of Tiago Antao
>
> Hi!
>
>   I've a problem in 6.5.3 which might be a bug (if not in pg, at least
> in my head)...
>
> --------------------------------------------------
> tiago=> declare c1 cursor for select * from treta;
> SELECT
> tiago=> fetch 1 in c1;
> ola|adeus
> ---+-----
>   1|bubu
> (1 row)
>
> tiago=> move backward all in c1;
> MOVE
> tiago=> fetch 1 in c1;
> ola|adeus
> ---+-----
> (0 rows)
> ---------------------------------------------------
>
> Shouldn't fetch return, in the 2nd run, the same thing as in the
> first???

You are right.
This was fixed in 7.0.

Regards.

Hiroshi Inoue
Inoue@tpf.co.jp