Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

Next:From: Bruce MomjianDate: 2000-06-11 03:48:27
Subject: Re: Bug in move 0
Previous:From: Tom LaneDate: 2000-06-11 03:47:09
Subject: Re: Bug in move 0

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group