From 68f3d25001b8c51c778ae199c9019dc3c18cdc9a Mon Sep 17 00:00:00 2001 From: 13693261870 <252740454@qq.com> Date: 星期三, 12 四月 2023 15:04:46 +0800 Subject: [PATCH] 1 --- data/db_fn.sql | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/data/db_fn.sql b/data/db_fn.sql index 27afa70..4d82156 100644 --- a/data/db_fn.sql +++ b/data/db_fn.sql @@ -313,7 +313,7 @@ $$ language plpgsql; select * from lf.sys_meta where depcode similar to '(00|01|02)%'; -select fn_dir_similar('鍩虹娴嬬粯'); select fn_dir_similar('娴嬮噺锛圗SV锛�'); select * from lf.sys_meta where dircode similar to fn_dir_similar('鍩虹娴嬬粯'); +select fn_dir_similar('鍩虹娴嬬粯'); select fn_dir_similar('娴嬬粯锛圗SV锛�'); select * from lf.sys_meta where dircode similar to fn_dir_similar('鍩虹娴嬬粯'); ----------------------------------------------------------------------------------------------------- 14.FME鏃ュ織琛ㄨЕ鍙戝櫒鍑芥暟 -- drop function fn_meta_insert(); create or replace function fn_meta_insert() returns trigger as $$ -- Gitblit v1.9.3