From 944091a18721ccd38a7c583acf2a6c68fa457990 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期三, 16 十一月 2022 10:05:36 +0800
Subject: [PATCH] 1
---
data/db_fn.sql | 7 +++----
1 files changed, 3 insertions(+), 4 deletions(-)
diff --git a/data/db_fn.sql b/data/db_fn.sql
index 9e519ae..acd2e6d 100644
--- a/data/db_fn.sql
+++ b/data/db_fn.sql
@@ -254,12 +254,12 @@
select to_char(optime,'yyyy-mm-dd') as optime,count(*) from lf.sys_login where optime between (select optime - interval '30 day')
and optime group by to_char(optime, 'yyyy-mm-dd') order by to_char(optime, 'yyyy-mm-dd') asc;
------------------------------------------------------------------------------------------------------
+
select a.*,coalesce(a.native,'') from lf.sys_user a;
select ST_PointFromText('POINT(95.80461853400004 34.13862467200005)');
select ST_LineFromText('LINESTRING(04.98985101830993 37.43840773692756,104.99318913447104 37.43883729720358)', 4326);
select ST_PolygonFromText('POLYGON((104.9907822932683 37.43532941961706,104.99088987736599 37.43532941961706,104.9908670336867 37.4349030213574,104.99078327712658 37.4349030213574,104.9907822932683 37.43532941961706))',4326);
-
+----------------------------------------------------------------------------------------------
-- 114ms锛�180/3248
select count(1) from bd.dlg_agnp a where ST_Intersects(geom,
ST_PolygonFromText('POLYGON ((115.94927385452 32.3754479115071 0,121.989371092554 32.2766788010181 0,121.850621222894 29.6874200067864 0,115.9727267226 29.7835368627922 0,115.94927385452 32.3754479115071 0))', 4326))
@@ -285,8 +285,7 @@
select a.* from lf.sys_domain a where exists (select * from lf.sys_dict b where b.ns = 'bd' and b.tab = 'dlg_25w_hyda') and a.dom_code like '210%' order by a.id
select * from lf.sys_download a where create_user = 1 and type = 2;
-
-
+----------------------------------------------------------------------------------------------
--
Gitblit v1.9.3