pgsql通过递归获取某组织的全称的函数

– 组织表
CREATE TABLE mdc.base_org
(
uuid character varying(32) NOT NULL, – 组织编码
name character varying(64) NOT NULL, – 组织名称
org_parent_uuid character varying(32) NOT NULL, – 上级组织编码
memo character varying(256), – 描述
delete_flag smallint NOT NULL, – 删除标志位:1-启用,0-删除
court_uuid character varying(32), – 小区uuid,用于云端同步
create_time timestamp(0) without time zone NOT NULL, – 创建日期
update_time timestamp(0) without time zone NOT NULL, – 修改日期
create_user character varying(32) NOT NULL, – 创建用户id
update_user character varying(32) NOT NULL, – 修改用户id
is_parent boolean NOT NULL, – 判断是否为父节点,若该节点下有组织或房屋则为父节点,true-父节点,false-非父节点
sort_by character varying(255) NOT NULL, – 排序字段,每3位代表一个级别,同级别该字段自动递增,根节点为001
org_type character varying(2) NOT NULL, – 组织类型:1-小区,2-期,3-楼栋,4-单元,5-楼层,6-门类型,7-其他
CONSTRAINT pk_base_org PRIMARY KEY (uuid)
)
WITH (
OIDS=FALSE
);

COMMENT ON TABLE mdc.base_o