From: | "Kuti Attila" <attika(at)elender(dot)hu> |
---|---|
To: | questions(at)postgresql(dot)org, docs(at)postgresql(dot)org |
Subject: | cursors in plpgsql function?? |
Date: | 1999-08-05 09:36:18 |
Message-ID: | 199908050934.LAA24411@mail.elender.hu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs |
Hi!
I have problem with declaring a cursor for a query in a plpgsql. I got
compile error, and parse error at or near cursor.
Here my function for a trigger:
What can be the problem?
Thanks a lot
Attila
create function p_kotogep() returns opaque as '
declare
ajanlid ajanlati_konyv_p.ajanlat_id%TYPE;
userid felhasznalo.user_id%TYPE;
megidop timestamp;
termekid termek.termek_id%TYPE;
menny portfolio.szabad_db%TYPE;
arr portfolio.szabad_db%TYPE;
iran ajanlati_konyv_p.irany%TYPE;
erv timestamp;
hany int4;
piar bool;
aktar termek.arfolyam%TYPE;
begin work;
select count(ajanlat_id) into hany from
ajanlati_konyv_p;
-- SOMEWHERE HERE I GET ALWAYS ERROR
declare ajanlatok cursor for select * from
ajanlati_konyv_p;
for i in 1..hany loop
fetch next from ajanlatok into
ajanlid, userid, megidop, termekid,
menny, arr, piar, iran, erv;
aktar= p_aktar(termekid);
if setup_olv(1) then -- arjegyzovel
jatszunk
if iran = 1 then -- vetel
if aktar <= arr then
insert into kotes_naplo_p (vevo_id,
elado_id, termek_id, ar, mennyiseg, szabad_valt)
values (userid, 1, termekid, arr, menny,
trktsg (menny, arr, 1) );
delete from ajanlati_konyv_p where
ajanlati_id = ajanlid;
else
end if;
else
if aktar >= arr then
insert into kotes_naplo_p (vevo_id,
elado_id, termek_id, ar, mennyiseg, szabad_valt)
values (1, userid, termekid, arr, menny,
trktsg (menny, arr, 1) );
delete from ajanlati_konyv_p where
ajanlati_id = ajanlid;
else
end if;
end if;
end if ; -- arjegyzovel jatszunk vege
end loop;
close ajanlatok;
commit work;
return NULL;
;
' language 'plpgsql';
trigger paj_kot on ajanlati_konyv_p;
trigger paj_kot
after insert on ajanlati_konyv_p
for each row
execute procedure p_kotogep();
attika(at)elender(dot)hu
http://www.bke.hu/~attika
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Lockhart | 1999-08-05 14:53:15 | New man pages |
Previous Message | Bruce Momjian | 1999-08-04 23:42:24 | Re: [DOCS] O'Reilly MySQL Book ... |