Falexom

Untitled

May 11th, 2023
188
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE OR REPLACE FUNCTION golden_ratio() RETURNS int AS
  2. $$
  3. DECLARE
  4. golden1 INT;
  5. golden2 INT;
  6. sum INT;
  7. first INT;
  8. last INT;
  9. indx INT;
  10. prelast INT;
  11. BEGIN
  12. first := (SELECT number FROM nums WHERE id = 1);
  13. indx := (SELECT max(id) FROM nums);
  14. last := (SELECT number FROM nums WHERE id = indx);
  15. prelast := (SELECT number FROM nums WHERE id = indx-1);
  16. golden1 := ROUND((prelast*(3-5^0.5)/2));
  17. golden2 := ROUND((last*(5^0,5-1)/2));
  18. sum := first + last + golden1 + golden2;
  19. RETURN sum;
  20. END $$ LANGUAGE plpgsql;
Add Comment
Please, Sign In to add comment