syntax « contrib « plugins « doc - ikiwiki-upstream - Unnamed repository; edit this file to name it for gitweb.

Mode	Name	Size
-rw-r--r--	discussion.mdwn	1116	log plain

"> end if;

select into dpt_id trans_id from dpt_trans where trans_id = new.id;

if dpt_id > 0 then

update dpt_trans set department_id = new.department_id where trans_id = dpt_id;

else

insert into dpt_trans (trans_id, department_id) values (new.id, new.department_id);

end if;

return NULL;

end;

' language 'plpgsql';

-- end function

-- department transaction table

create table dpt_trans (trans_id int, department_id int);

-- function del_department

create function del_department() returns trigger as '

begin

delete from dpt_trans where trans_id = old.id;

return NULL;

end;