All pastes #209621 Raw Edit

Trucs

public sql v1 · immutable
#209621 ·published 2006-10-19 08:20 UTC
rendered paste body
CREATE OR REPLACE FUNCTION refresh_community_tops() RETURNS int AS $$DECLAREBEGIN	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 197psql:stats_communities.sql:17: LINE 10:  FOR my_community IN SELECT id, path FROM _community LOOPpsql:stats_communities.sql:17:                                        ------------------------------------------------------------------------