postgresql 存储过程

togeth

于 2010-08-06 17:24:03 发布

阅读量129

点赞数

分类专栏： database 文章标签： PostgreSQL

本文链接：https://blog.youkuaiyun.com/togeth/article/details/83681006

版权

database 专栏收录该内容

2 篇文章

订阅专栏

本文介绍了一个使用PL/pgSQL编写的函数，该函数通过传入的登录名参数来删除数据库中的用户信息。具体操作包括从不同的表中删除与用户相关的记录。

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

CREATE OR REPLACE FUNCTION DELUSER(barcode text) RETURNS boolean AS $function$
DECLARE
  odd int;
  even int;
  s int;
BEGIN
  odd = CAST((select types from usr_login where loginname = barcode) AS int);
  even = CAST((select departid from usr_login where loginname = barcode) AS int);
  s = CAST((select userid from usr_login where loginname = barcode) AS int);
  IF odd=3 THEN
  
    delete from enterprise where enterpriseid = even;
    
  ELSE
    delete from depart where departid = even;
  END IF;
  delete from usr_userinfo where userid = s;
  delete from usr_login where loginname = barcode;
   return true;
END;
$function$ LANGUAGE plpgsql;