From 79454ce9fbb025d35b7b28144bc9306cf9e546e3 Mon Sep 17 00:00:00 2001 From: 13693261870 <252740454@qq.com> Date: 星期六, 25 二月 2023 15:24:33 +0800 Subject: [PATCH] 1 --- data/db_cx.sql | 7 ++----- 1 files changed, 2 insertions(+), 5 deletions(-) diff --git a/data/db_cx.sql b/data/db_cx.sql index 452884d..0f8cc35 100644 --- a/data/db_cx.sql +++ b/data/db_cx.sql @@ -319,11 +319,6 @@ ) SELECT N::NUMERIC(30, 0) FROM T WHERE LENGTH(S) < 1; ---------------------------------------------------------------------------------------------- -1.娴嬭瘯 -select id,name from lf.sys_dir where name in ('娴嬮噺锛圗SV锛�','鍕樺療锛圗GE锛�','鍦扮伨锛圗GD锛�','娲炲簱锛圗GD锛�') order by name; - -select (select string_agg(cast(id as varchar),',') from lf.sys_dir where name = a.name) "key",name "value" from lf.sys_dir a -where name in ('娴嬮噺锛圗SV锛�','鍕樺療锛圗GE锛�','鍦扮伨锛圗GD锛�','娲炲簱锛圗GD锛�') group by name order by name; - select (select string_agg(code, ',') from lf.sys_dir where name = a.name) "key", name "value" from lf.sys_dir a where name in ('鍩虹娴嬬粯', '鍩虹鍦扮伨', '鍩虹鍕樺療', '鍚堣鏁版嵁', '绠$悊鏁版嵁', '娴嬮噺锛圗SV锛�', '鍕樺療锛圗GE锛�', '鍦扮伨锛圗GD锛�', '娲炲簱锛圗GD锛�') @@ -340,3 +335,5 @@ + + -- Gitblit v1.9.3