logo
publist
写文章

简介

该用户还未填写简介

擅长的技术栈

未填写擅长的技术栈

可提供的服务

暂无可提供的服务

GitHub 指令

无

#python
pgsql 实现oracle的start with与层级树level

oracleSELECT LEVEL AS LVL,TPL.PORT_ID,TPL.PARENT_PORTIDFROM TN_PONLINK TPLSTART WITH TPL.DEV_ID = 'F62A1470D64111E6990CAC577F000001'CONNECT BY PRIOR

#oracle#数据库
pgsql数据库报错:because it does not have a replica identity and publishes updates

报错信息:SQL 错误 [55000]: ERROR: cannot delete from table "xxxxx" because it does not have a replica identity and publishes updatesHint: To enable updating from the table, set REPLICA IDENTITY using ALTER

#数据库#sql
pgsql 列转行

1单表查询结果出来只有一行结果select * from table;2现在将查询结果由列转为行展示select unnest(string_to_array(concat_ws(',',a.t_dev_names,a.t_dev_ids,a.T_PORT_NAMES,a.T_PORT_IDS),',')) as result from table as a步骤分析:concat_ws:将几个字段

暂无文章信息