CREATE OR REPLACE FUNCTION refresh_community_tops() RETURNS int AS $$
DECLARE
BEGIN

	TRUNCATE TABLE _top_community;

	FOR my_community IN SELECT id, path FROM _community LOOP
	
		
	END LOOP;

	RETURN 1;
END;
$$  LANGUAGE plpgsql;

-------------------------------------------------------

psql:stats_communities.sql:17: ERROR:  loop variable of loop over rows must be record or row variable at or near "LOOP" at character 197
psql:stats_communities.sql:17: LINE 10:  FOR my_community IN SELECT id, path FROM _community LOOP
psql:stats_communities.sql:17:                                        

------------------------------------------------------------------------