loop-and-update.sql

do
$do$
begin
	for i in 1..100 loop
		update hit_stats hs_outer
				set title=(select title from hit_stats where hit_stats.site=hs_outer.site and hit_stats.path=hs_outer.path order by hit_stats.day desc limit 1)
		where title='' and site=i;
		perform pg_sleep(5);
	end loop;
end
$do$;