cursor/ array in a function

Started by jpremover 25 years ago1 messagesgeneral
Jump to latest
#1jprem
jprem@srmsoft.co.in

hello,
i have a function and a trigger as below.
-----------------------------------------------------------------------------------

create function testfunction() returns opaque
as
'declare
del_gid integer;
len integer;
j integer;
begin
select into empcount emp_id from emp where emp_id not in
(select emp_id
from dept);
if found then
j=0;
while j = empcount loop
delete from emp where emp_id = empcount;
end loop;
end if;
return null;
end;'
language 'plpgsql';

create trigger testtrigger after delete on X for each row
execute procedure testfunction();
----------------------------------------------------------------------------------

the tables X,emp and dept are related.when i delete a value from X , i
need to check for some values of empid in dept.if those values are not
found in dept then i have to delete those corresponding values from emp.

i heard from the discussion forum that plpgsql doesn't support cursors.
what i need is to store a set of values i na variable and fetch one by
one.
can i use array in a function or how to achieve this functionality in
PostgreSQL 6.5.3 ?

can anyone help me ? thanx in advance.