RosettaCodeData/Task/Fibonacci-sequence/PL-pgSQL/fibonacci-sequence-2.sql
2020-02-17 23:21:07 -08:00

5 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;