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