All pastes #341153 Raw Edit

Someone

public text v1 · immutable
·published 2007-02-05 11:06 UTC
rendered paste body
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 || ', ' ||
				'''' || blogRank.tree || '''' || ', ' ; 

	END LOOP;

	RETURN 1;
END;
$$ language plpgsql;