RE: [GENERAL] FETCH/MOVE problem - Mailing list pgsql-general

From Hiroshi Inoue
Subject RE: [GENERAL] FETCH/MOVE problem
Date
Msg-id 000901bf870a$7b1d3e40$2801007e@tpf.co.jp
Whole thread Raw
In response to FETCH/MOVE problem  (Tiago Antao <tiagoantao@bigfoot.com>)
List pgsql-general
> -----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

pgsql-general by date:

Previous
From: Charles Tassell
Date:
Subject: Re: [GENERAL] binary data & LOBs
Next
From: Francis K Shim
Date:
Subject: PostgreSQL accessing a M$ Access DB?