for loop to fetch records from select in postgresql

for_loop_postgresql.sql

-- An implicite cursor in PostgreSQL PLPGSQL.
-- 
-- The main idea is to declare a cursor in the loop header
-- and fetch the rows inside the loop

do $$
declare 
  rec record;
begin
  for rec in 
    select * 
      from accounts 
      order by lastname, firstname 
  loop
    raise notice '% - %', rec.firstname, rec.lastname;
  end loop;
end
$$;