Skip to content

Instantly share code, notes, and snippets.

@freeformz
Created June 4, 2012 07:06
Show Gist options
  • Save freeformz/2866845 to your computer and use it in GitHub Desktop.
Save freeformz/2866845 to your computer and use it in GitHub Desktop.
PL/PGSQL fizzbuzz
CREATE OR REPLACE FUNCTION fizzbuzz()
RETURNS setof text as $$
BEGIN
FOR i IN 1 .. 100 LOOP
IF MOD(i, 15) = 0 THEN
return next 'FizzBuzz';
ELSIF MOD(i, 5) = 0 THEN
return next 'Buzz';
ELSIF MOD(i, 3) = 0 THEN
return next 'Fizz';
ELSE
return next i::text;
END IF;
END LOOP;
RETURN;
END;
$$ LANGUAGE plpgsql;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment