FETCH/MOVE problem

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

Responses

Browse pgsql-general by date

  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