=====================================================================
POSTGRESQL BUG REPORT TEMPLATE
=====================================================================
Your name : Jutso Hung
Your email address : [EMAIL PROTECTED]
System Configuration
---------------------
Architecture (example: Intel Pentium) : AMD K6
Operating System (example: Linux 2.0.26 ELF) : Linux 2.2.12-20
PostgreSQL version (example: PostgreSQL-6.5.3): PostgreSQL-7.0Beta1
Compiler used (example: gcc 2.8.0) : egcs-2.91.66
Please enter a FULL description of your problem:
------------------------------------------------
If declare a cursor for a query, and move with 0. Then can not
fetch any record !
a example:
template1=# select * from emp;
empno | name
--------+------------
100001 | John Smith
100002 | Mary White
100003 | Joe Brown
(3 rows)
template1=# begin;
BEGIN
template1=# declare x cursor for select * from emp;
SELECT
template1=# move 0 in x;
MOVE
template1=# fetch all in x;
empno | name
-------+------
(0 rows)
template1=# move backward all in x;
MOVE
template1=# fetch all in x;
empno | name
--------+------------
100001 | John Smith
100002 | Mary White
100003 | Joe Brown
(3 rows)
Jutso Hung <[EMAIL PROTECTED]>
