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-09 17:13:33
Message-ID: 200006091713.NAA18488@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
I can confirm this bug still exists in the code.  Sorry.


> =====================================================================
>                             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

Responses

pgsql-bugs by date

Next:From: Giles LeanDate: 2000-06-09 20:07:28
Subject: Re: [HACKERS] Sigh, LIKE indexing is *still* broken in foreign locales
Previous:From: Bruce MomjianDate: 2000-06-09 15:56:11
Subject: Re: grant/revoke bug with delete/update

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