with recursive 递归查取所有子目录数据
摘要:
WITH RECURSIVE T (node_id, p_id, path, DEPTH) AS (SELECT node_id,p_id,array[node_id || '|' || node_type || '|' || type_value] as path,1 AS DEPTH FROM 阅读全文
posted @ 2023-05-09 17:09 Yr-Zhang 阅读(48) 评论(0) 推荐(0) 编辑