-- $1 is userid
CREATE OR REPLACE FUNCTION getrolename(integer) RETURNS character varying AS '
DECLARE
    _name varchar;
  BEGIN
    SELECT INTO _name role.name FROM role LEFT JOIN contact ON contact.role = role.id WHERE contact.id = $1;
    RETURN _name;
  END;
' LANGUAGE plpgsql;
