postgresql函数示例

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了postgresql函数示例，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含1245字，纯文字阅读大概需要2分钟。

内容图文

CREATE?OR?REPLACE?FUNCTION?"public"."p_update_dist_full_path"()
??RETURNS?"pg_catalog"."void"?AS?$BODY$?
DECLARE
?????c_record?record;
?????c_temp?record;
?????exesql?varchar;
?????c_code?varchar;
?????BEGIN
??????update?table_district?set?id_full_path='',code_full_path='',name_full_path='';
? ? ? update?table_district?set?id_full_path=id,code_full_path=code,name_full_path=name?where?id='1';
??????for?c_record?in
???????select?id,pid,n?from?table_district?_r?where?n>=0?and?id?!=1?order?by?n?desc?
??????loop
???????select?id::varchar,code,name?INTO?c_temp?from?table_district?where?id=?c_record.pid;
???????if?c_temp.code?=?''?or?c_temp.code?is?null?THEN
??????????update?table_district?set?id_full_path=(CASE?id_full_path?WHEN?''?then?c_temp.id?else?concat(id_full_path,',',c_temp.id)?END),name_full_path=concat(name_full_path,'/',c_temp.name)?where?id?=?c_record.id;
???????else
??????????update?table_district?set?id_full_path=(CASE?id_full_path?WHEN?''?then?c_temp.id?else?concat(id_full_path,',',c_temp.id)?END),code_full_path=concat(code_full_path,'/',c_temp.code),name_full_path=concat(name_full_path,'/',c_temp.name)?where?id?=?c_record.id;
????????end?if;
??????end?loop;
??????END;?
$BODY$
??LANGUAGE?plpgsql?VOLATILE
??COST?100

内容总结

以上是互联网集市为您收集整理的postgresql函数示例全部内容，希望文章能够帮你解决postgresql函数示例所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端