cursor/ array in a function
От | jprem |
---|---|
Тема | cursor/ array in a function |
Дата | |
Msg-id | 39729FF1.D020D93E@srmsoft.co.in обсуждение исходный текст |
Список | pgsql-general |
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.
В списке pgsql-general по дате отправления: