Prime Number

CREATE OR REPLACE FUNCTION is_prime(v_num INTEGER)
RETURNS TEXT AS $$
DECLARE
	i INTEGER;
	max_limit INTEGER;
BEGIN

	max_limit := FLOOR(SQRT(v_num));

	FOR i IN 2..max_limit LOOP
		IF v_num % i = 0 THEN
			RETURN 'Not Prime';
		END IF;
	END LOOP;

	RETURN 'Prime';
END;
$$ LANGUAGE plpgsql;