From 1111a9b9baeaed10c2d2b6d6370b856f19a38c92 Mon Sep 17 00:00:00 2001 From: 13693261870 <252740454@qq.com> Date: 星期六, 25 三月 2023 17:53:30 +0800 Subject: [PATCH] 1 --- data/db_cx.sql | 8 +++----- 1 files changed, 3 insertions(+), 5 deletions(-) diff --git a/data/db_cx.sql b/data/db_cx.sql index 1207dfd..5758ee9 100644 --- a/data/db_cx.sql +++ b/data/db_cx.sql @@ -7,13 +7,11 @@ select concat(gb, '_', name) from bd.dlg_agnp limit 10; select ST_AsText(geom) "geom", a.*, fn_get_fullname(a.depid, 1) depName, fn_get_fullname(a.dirid, 2) dirName, fn_uname(create_user) createName, fn_uname(update_user) updateName from lf.sys_publish a -select * from lf.sys_fme_log order by id desc limit 10; -- 236 -select * from lf.sys_meta order by id desc limit 10; -- 1686 > 1696 +select * from lf.sys_fme_log order by id desc limit 10; -- 242 > +select * from lf.sys_meta order by id desc limit 10; -- 1686 > select * from lf.sys_fme_log -where count > 0 and update_time is null and -position(tcdm in 'bd.b_pac_hydrogeology,bd.b_pac_frozensoil,bd.b_pac_geologic_hazard,bd.b_pac_marine_meteorological,bd.b_pac_meteorological,bs.m_equipment_nameplate,bs.m_hydraulic_protection,bs.m_marker,bs.s_explorationpoint,bs.u_sectionline') > 0 - --and create_time > now()::timestamp + '-1 min' +where count > 0 and update_time is null and create_time > now()::timestamp + '-1 min' -- Gitblit v1.9.3