From 8e5b20232ff7cbde09ed80169f42dbba561d0a3c Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期二, 14 二月 2023 15:38:23 +0800
Subject: [PATCH] 1
---
data/db_fn.sql | 6 +++---
data/db_cx.sql | 2 ++
data/update.sql | 2 +-
3 files changed, 6 insertions(+), 4 deletions(-)
diff --git a/data/db_cx.sql b/data/db_cx.sql
index bc52b34..097ed15 100644
--- a/data/db_cx.sql
+++ b/data/db_cx.sql
@@ -6,7 +6,9 @@
create extension fuzzystrmatch;
create extension postgis_tiger_geocoder;
create extension address_standardizer;
+create extension "uuid-ossp";
+select uuid_generate_v4(); -- uuid锛�36浣�
select split_part('12.34.56.78', '.', 1); -- 鍒囧壊
select substr('FY2021', 3, 2); -- 鎻愬彇
select substring('FY2021' FROM 3 for 2); -- 鎻愬彇
diff --git a/data/db_fn.sql b/data/db_fn.sql
index 7d1b640..542edc3 100644
--- a/data/db_fn.sql
+++ b/data/db_fn.sql
@@ -16,9 +16,9 @@
end;
$body$ language 'plpgsql' volatile security definer;
-select new_guid();
+select new_guid(); select length(md5('-')); select uuid_generate_v4();
----------------------------------------------------------------------------------------------------- 02.閫掑綊鏌ヨ鍑芥暟
--- drop function rec_query_dep(integer, varchar);
+-- drop function fn_rec_query(integer, varchar);
create or replace function fn_rec_query(id integer, tab varchar)
returns varchar as $$
declare
@@ -157,7 +157,7 @@
$$ language plpgsql;
select fn_get_entity('dlg_25w_boua_s');
------------------------------------------------------------------------------------------------------ 08.鏌ヨ瀛楀吀琛ㄥ苟缁熻璁板綍
+----------------------------------------------------------------------------------------------------- 08.鏌ヨ瀛楀吀琛ㄥ苟缁熻璁板綍 *
-- drop function fn_tab_count(varchar, varchar, varchar, integer);
create or replace function fn_tab_count(ns varchar, tab varchar, dirs varchar, depid integer)
returns integer as $$
diff --git a/data/update.sql b/data/update.sql
index 617c551..ceac550 100644
--- a/data/update.sql
+++ b/data/update.sql
@@ -146,7 +146,7 @@
select * from lf.sys_user limit 10;
select * from lf.sys_dep where id=0
select * from lf.sys_res;
-
+select * from lf.sys_ver;
--
Gitblit v1.9.3