FETCH/MOVE problem
От | Tiago Antao |
---|---|
Тема | FETCH/MOVE problem |
Дата | |
Msg-id | 38C2E059.582D3EAA@bigfoot.com обсуждение исходный текст |
Ответы |
RE: [GENERAL] FETCH/MOVE problem
|
Список | 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
В списке pgsql-general по дате отправления: