From ae3ca6829a5bae6088b6f6a005377f11fee03df8 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期一, 31 十月 2022 17:17:37 +0800
Subject: [PATCH] 1
---
data/db_fn.sql | 13 ++++---------
1 files changed, 4 insertions(+), 9 deletions(-)
diff --git a/data/db_fn.sql b/data/db_fn.sql
index 985f573..9857e0a 100644
--- a/data/db_fn.sql
+++ b/data/db_fn.sql
@@ -236,12 +236,9 @@
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 * from lf.sys_menu order by id;
-
-select * from lf.sys_blacklist where type = 1;
-select * from lf.sys_operate where modular1 is null or modular2 is null;
-select count(*) from bd.dlg_agnp;
-select count(*) from bd.dlg_25w_aanp;
+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,
@@ -252,9 +249,7 @@
and 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))
-select id,uname "name" from lf.sys_user where uname like '%瀹�%' order by uname limit 10;
-select id,name from lf.sys_dep where name like '%鍙�%' order by order_num limit 10;
-
+select st_astext(geom) from bd.dlg_25w_hfcl limit 10;
--
Gitblit v1.9.3