> you can either set RaiseError, or check the returned set

Setting RaiseError will not tell whether rows have been selected - it is not an error to make a SELECT statement that finds 0 rows.