From: | Tiago Antao <tiagoantao(at)bigfoot(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | FETCH/MOVE problem |
Date: | 2000-03-05 22:31:53 |
Message-ID: | 38C2E059.582D3EAA@bigfoot.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Charles Tassell | 2000-03-05 22:44:43 | Re: [GENERAL] binary data & LOBs |
Previous Message | Alfred Perlstein | 2000-03-05 20:42:15 | Re: [GENERAL] ERROR: copyObject: don't know how to copy 704 |