总算写对了一个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 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;

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!