RosettaCodeData/Task/Fibonacci-sequence/PL-pgSQL/fibonacci-sequence-2.sql

6 lines
162 B
PL/PgSQL

CREATE OR REPLACE FUNCTION fibFormula(n INTEGER) RETURNS INTEGER AS $$
BEGIN
RETURN round(pow((pow(5, .5) + 1) / 2, n) / pow(5, .5));
END;
$$ LANGUAGE plpgsql;