PostgreSQL创建存储过程

辰星，陨落

已于 2022-04-08 16:40:43 修改

阅读量5.4k

点赞数

文章标签： postgresql 数据库

于 2022-03-15 15:47:34 首次发布

本文链接：https://blog.youkuaiyun.com/qq_60509834/article/details/123504428

版权

本文详细介绍了如何在PostgreSQL数据库中创建和操作存储过程，包括添加、删除和修改公告等具体步骤，帮助读者深入理解PostgreSQL的存储过程功能。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1，添加公告

-- PROCEDURE: public.pr_notice_info_add(character varying, text, integer, integer, integer, integer, character varying, character varying, character varying, character varying, integer, integer)

-- DROP PROCEDURE public.pr_notice_info_add(character varying, text, integer, integer, integer, integer, character varying, character varying, character varying, character varying, integer, integer);

CREATE OR REPLACE PROCEDURE public.pr_notice_info_add(
	noticetitle character varying,
	noticecontent text,
	provinceid integer,
	cityid integer,
	districtid integer,
	streetid integer,
	isshow integer,
	INOUT returnvalue integer)
LANGUAGE 'plpgsql'
AS $BODY$
	declare stack text;
	declare provincename character varying;--省名称
	declare cityname character varying;--市名称
	declare districtname character varying;--县区名称
	declare streetname character varying;--街道名称
begin
	returnvalue=0;
  	provincename='';
  	cityname='';
 	districtname&

最低0.47元/天解锁文章