cwmars.change_password

CREATE OR REPLACE FUNCTION cwmars.change_passwd(userid INT, newpasswd TEXT, passwdtype TEXT DEFAULT 'main')
RETURNS VOID AS $$
DECLARE
    newsalt TEXT;
BEGIN
    SELECT actor.create_salt(passwdtype) INTO newsalt;
    PERFORM actor.set_passwd(userid, passwdtype, md5(newsalt || md5(newpasswd)), newsalt);
END;
$$ LANGUAGE 'plpgsql';