Content-Type: text/plain; charset="us-ascii"
Date: Mon, 13 Aug 2007 21:29:52 +0200
From: "Christian Kindler" <christian.kindler@gmx.net>
Message-ID: <20070813192952.76820@gmx.net>
MIME-Version: 1.0
Subject: how to moce back in refcursor
To: pgsql-sql@postgresql.org
Content-Transfer-Encoding: 7bit

Hi

I have never worked with cursors but for now I have to step back on special events to calculate a difference. So I have this sample code tested but I can not "move" in my cursor. I have lokke at docs but this didn't help me. Can you say how to declare my cursor to step back?

Thank You
Chris

PS code sample
create table fimi.eodbar(fi_id int8, market_id int8);
insert into fimi.eodbar values(322,200);

create or replace function fimi.test("fiid" int8) returns setof int as
$BODY$
DECLARE
  cur1 REFCURSOR;
  foo int;

BEGIN
  OPEN cur1 FOR execute('select market_id from fimi.eodbar where fi_id=' || "fiid");

   loop
    fetch cur1 into foo;

    if not found then
       exit ;
    else
       -- move -1 in cur1;
       fetch cur1 into foo;
       return next foo;
    end if;
   
   end loop;
close cur1; 

END;
$BODY$
LANGUAGE 'plpgsql' VOLATILE;
ALTER FUNCTION fimi.getfoo(bpchar) OWNER TO fimi;

select * from fimi.test(322);
-- 
cu
Chris

GMX FreeMail: 1 GB Postfach, 5 E-Mail-Adressen, 10 Free SMS.
Alle Infos und kostenlose Anmeldung: http://www.gmx.net/de/go/freemail