pgsql存储过程（实例）

最新推荐文章于 2024-07-31 16:35:24 发布

凡人·没有梦

最新推荐文章于 2024-07-31 16:35:24 发布

阅读量9.1k

点赞数 2

分类专栏： sql 文章标签： sql function

本文链接：https://blog.csdn.net/pleasurehappy/article/details/38494185

版权

sql 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

pg存储过程简单示例：

create or replace function select_resource_produrce(IN mprCode text , IN publicationType text , OUT resourceName text ,OUT resourceId int8)
returns record as
$BODY$ 
BEGIN

	if publicationType = '1' then
		  select book_name_cn ,
						 book_id 
       into resourceName,resourceId
          from t_book
         where mpr_code = mprCode;
  end if;

	if publicationType = '2' then
		  select periodical_name_cn ,
						 periodical_id 
       into resourceName,resourceId
          from t_periodical
         where mpr_code = mprCode;
  end if;

	if publicationType = '3' then
		  select newspaper_name_cn ,
						 newspaper_id 
       into resourceName,resourceId
          from t_newspaper
         where mpr_code = mprCode;
  end if;

	if publicationType = '4' then
		  select audio_name_cn ,
						 audio_id 
       into resourceName,resourceId
          from t_audio
         where mpr_code = mprCode;
  end if;

END;
$BODY$
language plpgsql;

SELECT * from select_resource_produrce('0000000226' , '1')

调用：SELECT * from select_resource_produrce('0000000226' , '1')