Re: Bug in move 0

Seems MOVE 0 moves to the end of the cursor.  The FETCH manual says:


              SQL92 allows one to repetatively retrieve the  cur-
              sor at its "current position" using the syntax

              FETCH RELATIVE 0 FROM cursor



              Postgres does not currently support this notion; in
              fact the value zero is reserved  to  indicate  that
              all  rows  should be retrieved and is equivalent to
              ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
              specifying the ALL keyword.  If the  RELATIVE  key-
              word  has  been used, the Postgres assumes that the
              user intended SQL92 behavior and returns this error
              message.


> =====================================================================
>                             POSTGRESQL BUG REPORT TEMPLATE
> =====================================================================
>
>
> Your name               : Jutso Hung
> Your email address      : jutso@tpts5.seed.net.tw
>
>
> 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 <jutso@tpts5.seed.net.tw>
>
>
>


--
  Bruce Momjian                        |  http://www.op.net/~candle
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026