Untitled

CREATE OR REPLACE function updateTopBlog(Vdate2process DATE) 
	RETURNS TEXT AS $$
DECLARE
	blogRank RECORD;
BEGIN

	FOR blogRank IN 
		SELECT idblog, obr, text2ltree('0.1.' || idblog) AS tree, pub 
		FROM   stats_day_blog 
		WHERE  day = Vdate2process 
		AND    obr > 0 
		ORDER BY obr DESC LOOP

		RETURN 			
			'INSERT INTO _top_blog_2 (id, rank, path, rank_pub) ' || 
			'VALUES (' ||
				blogRank.idblog || ', ' ||
				blogRank.obr || ', ' ;
	END LOOP;

	RETURN 1;
END;
$$ language plpgsql;