CREATE OR REPLACE FUNCTION sp_retrieve_authorizedroles2 (vchar_username character varying  , vchar_password character varying ) RETURNS integer AS
$$

DECLARE
        int_result  integer;
BEGIN
        select into int_result (SELECT roleid FROM users  WHERE vchar_username=username and vchar_password=password);

        IF int_result is null or int_result < 0 THEN
                RETURN 0;
        ELSE
                RETURN int_result;
        END IF;
          return int_result;
END;
$$ LANGUAGE plpgsql;