postgresql 存储过程

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;