RE: [GENERAL] FETCH/MOVE problem

> -----Original Message-----
> From: owner-pgsql-general(at)postgreSQL(dot)org
> [mailto:owner-pgsql-general(at)postgreSQL(dot)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(at)tpf(dot)co(dot)jp