postgres for loop

pg-for-loop.sql

DO $$
DECLARE
  st_time TIMESTAMP WITH TIME ZONE := '2016-03-01';
  p RECORD;
BEGIN
  RAISE INFO 'stat time is: % :', st_time;
  FOR p IN
    SELECT
      r.id, r.water_source_code, r.water_source_name
    FROM public.water_source_month_report r
    WHERE r.stat_time = st_time and r.water_source_code <> ''
  LOOP
    RAISE INFO '%', p;
  END LOOP;

END $$;