if (not found)
then
  raise notice 'Not found';
  return 1;
end if;