Procedure with out parameters. - Mailing list pgsql-novice

Hi,

 

I can not get a procedure with output parameter created. Right now, I am getting error on the line of "uid := newid;". If I remove the line, I got error saying that "Function myuser_insert(...) does not exist". Can anyone point out what's wrong here? - thanks. I want to retrieve the new UserID generated by the insert command.

 

CREATE FUNCTION myuser_insert(IN" mail" "varchar", IN" pass" "varchar", OUT" uid" int8) AS
$BODY$declare
 newid int8 := 0;
begin

  select into newid nextval('myuser_userid_seq');

  insert into myuser (userid, email, pwd) values (newid, mail, pass);

  uid := newid;

end$BODY$
LANGUAGE 'plpgsql' VOLATILE;