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

DECLARE
        int_result  users%ROWTYPE;
BEGIN
        select roleid into int_result  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;