总算写对了一个PostgreSQL函数，保存下来

概述CREATE OR REPLACE FUNCTION "public"."addadmin" (p_passport varchar, p_password varchar, p_adminname varchar, p_adminnickname varchar) RETURNS integer AS$body$declareinsertresult integer;begin  if exis

CREATE OR REPLACE FUNCTION "public"."addadmin" (p_passport varchar,p_password varchar,p_adminname varchar,p_adminnickname varchar) RETURNS integer AS$body$declareinsertresult integer;begin if exists(select 1 from public.t_admin where passport = $1) then begin insertresult:=-1;end; else begin insert into public.t_admin (passport,password,adminname,adminnickname) values($1,md5($2),$3,$4); insertresult:=(select adminID from public.t_admin where passport = $1); end; end if;return insertresult;EXCEPTIONWHEN others THEN return -1;end;$body$LANGUAGE 'plpgsql' VolATILE CALLED ON NulL input Security INVOKER;--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------CREATE OR REPLACE FUNCTION "public"."userreg" (p_passport varchar,p_nickname varchar,out "P_password" integer,out p_userID integer) RETURNS record AS$body$declareinsertresult integer;tmpstr varchar(20);beginif exists(select 1 from public.t_user where passport = $1) then begin $4:=-1; end; else begin $3 := round((random()+1) * 9999999 ); tmpstr := cast ($3 as varchar); tmpstr := md5(tmpstr); insert into public.t_user (passport,nickname) values($1,tmpstr,$2); $4:=(select userID from public.t_user where passport = $1); end; end if;end;$body$LANGUAGE 'plpgsql' VolATILE CALLED ON NulL input Security INVOKER;

总结

以上是内存溢出为你收集整理的总算写对了一个PostgreSQL函数，保存下来全部内容，希望文章能够帮你解决总算写对了一个PostgreSQL函数，保存下来所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。