postgres=#
postgres=# CREATE FUNCTION "count_by_two" (integer) RETURNS integer AS '
postgres'# DECLARE
postgres'# userNum ALIAS FOR $1;
postgres'# i integer;
postgres'# BEGIN
postgres'# i := 1;
postgres'# WHILE userNum < 20 LOOP
postgres'# i = i+1;
postgres'# return userNum;
postgres'# END LOOP;
postgres'#
postgres'# END;
postgres'# ' LANGUAGE 'plpgsql';
CREATE FUNCTION
postgres=#
postgres=# select count_by_two(12);
count_by_two
--------------
12
(1 row)
postgres=#
|