随笔分类 -  postgres

postgres递归查询所有子部门
摘要：WITH RECURSIVE T ( ID, parent_id,depart_name ) AS ( SELECT A.ID, A.parent_id, a.depart_name FROM sys_depart A WHERE A.id = 'bcb9dc287fbe40178162a6f9c8 阅读全文
posted @ 2020-10-13 15:27 幸福在靠近 阅读(1155) 评论(0) 推荐(0)
postgres生成uuid
摘要：安装 uuid_generate_v4() 扩展函数 create extension "uuid-ossp" 检验函数 select replace(uuid_generate_v1()::text,'-','') 阅读全文
posted @ 2020-07-15 08:46 幸福在靠近 阅读(1116) 评论(0) 推荐(0)