SQLize | PHPize | SQLtest

-- Drop the function if it exists DROP FUNCTION IF EXISTS fast_exponentiation(DOUBLE PRECISION, INTEGER); -- Create a new function CREATE OR REPLACE FUNCTION fast_exponentiation( base DOUBLE PRECISION, exponent INTEGER ) RETURNS DOUBLE PRECISION AS $$ DECLARE result DOUBLE PRECISION := 1.0; abs_exponent INTEGER := ABS(exponent); BEGIN -- Handle 0^0 IF base = 0 AND exponent = 0 THEN RETURN 1.0; END IF; -- Handle 0^positive IF base = 0 THEN RETURN 0.0; END IF; -- Handle negative exponent IF exponent < 0 THEN base := 1.0 / base; END IF; WHILE abs_exponent > 0 LOOP IF abs_exponent % 2 = 1 THEN result := result * base; END IF; base := base * base; abs_exponent := abs_exponent / 2; END LOOP; RETURN result; END; $$ LANGUAGE plpgsql;