root/trunk/sql/postgresql/makeNumSeq.sql

DROP FUNCTION makeNumSeq(INT);

CREATE FUNCTION makeNumSeq(INT) RETURNS void AS '
DECLARE i INT:=1;
BEGIN  
  DELETE FROM numSequence;
  WHILE i<=$1 LOOP
    INSERT INTO numSequence (n) VALUES (i);
    i:=i+1;
  END LOOP;
END;
' LANGUAGE plpgsql;

SELECT makeNumSeq(500);