Re: Bug in move 0

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: jutso(at)tpts5(dot)seed(dot)net(dot)tw
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Bug in move 0
Date: 2000-06-11 03:47:11
Message-ID: 200006110347.XAA16713@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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(at)tpts5(dot)seed(dot)net(dot)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(at)tpts5(dot)seed(dot)net(dot)tw>
>
>
>

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

Browse pgsql-bugs by date

  From Date Subject
Next Message Bruce Momjian 2000-06-11 03:48:27 Re: Bug in move 0
Previous Message Tom Lane 2000-06-11 03:47:09 Re: Bug in move 0