From a79ccae02cf7125735e5c1c4c0541fd288338828 Mon Sep 17 00:00:00 2001 From: 13693261870 <252740454@qq.com> Date: 星期一, 13 二月 2023 15:43:33 +0800 Subject: [PATCH] 1 --- data/db_fn.sql | 14 ++++++++++++++ 1 files changed, 14 insertions(+), 0 deletions(-) diff --git a/data/db_fn.sql b/data/db_fn.sql index 1aa9547..a02170e 100644 --- a/data/db_fn.sql +++ b/data/db_fn.sql @@ -343,8 +343,22 @@ /*insert into lf.sys_dep (pid,name,level,order_num) values (0,'鏂板崟浣�',1,2); delete from lf.sys_dep where pid = 0 and id > 1;*/ ----------------------------------------------------------------------------------------------------- 15.鐩綍琛ㄨЕ鍙戝櫒 +-- drop function fn_dir_insert(); +create or replace function fn_dir_insert() returns trigger as $$ + begin + update lf.sys_dir set code = fn_get_next_code(new.pid, 2) where id = new.id; + + return new; + end; +$$ language plpgsql; +-- drop trigger fn_dir_trigger on lf.sys_dep; +create or replace trigger fn_dir_trigger after insert on lf.sys_dir +for each row execute procedure fn_dir_insert(); +select * from lf.sys_dir where pid = 0 order by id; +/*insert into lf.sys_dir (pid,name,level,order_num) values (0,'鏂扮洰褰�',1,6); +delete from lf.sys_dir where pid = 0 and id > 309;*/ ----------------------------------------------------------------------------------------------------- 16.璺緞鍒嗘瀽 -- 鍒犻櫎宸插瓨鍦ㄧ殑鍑芥暟 drop function pgr_fromAtoB(varchar, double precision, double precision, double precision, double precision); -- Gitblit v1.9.3