do $$ declare item RECORD; begin for item in (select first_name, last_name from staff) loop raise notice '% | %', item.first_name, item.last_name; end loop; end $$;