Writing a PostgreSQL Function to check Even or Odd Numbers
Function to Check if a Number is Even or Odd
Write a PostgreSQL function that checks if a number is even or odd and returns a corresponding message.
Solution:
-- Create a function named check_even_odd that takes an integer as input and returns a text value
CREATE FUNCTION check_even_odd(n INT) RETURNS TEXT AS $$
BEGIN
-- Check if the number is even by using the modulo operator
IF n % 2 = 0 THEN
-- Return 'Even' if the number is even
RETURN 'Even';
ELSE
-- Return 'Odd' if the number is odd
RETURN 'Odd';
END IF;
END;
-- Specify the language used in the function as PL/pgSQL
$$ LANGUAGE plpgsql;
Explanation:
- Purpose of the Query:
- Determines whether a given number is even or odd.
- Key Components:
- IF n % 2 = 0 THEN RETURN 'Even'; ELSE RETURN 'Odd'; → Checks divisibility by 2
- Real-World Application:
- Useful in game development, analytics, and statistical applications.
For more Practice: Solve these Related Problems:
- Write a PostgreSQL function that checks if a number is prime.
- Write a PostgreSQL function that returns "Positive" or "Negative" based on the input number.
- Write a PostgreSQL function that checks if a number is a multiple of both 3 and 5.
- Write a PostgreSQL function that determines if a number is odd and greater than 100.
Have another way to solve this solution? Contribute your code (and comments) through Disqus.
Previous PostgreSQL Exercise: Function to Get Employee Full Name.
Next PostgreSQL Exercise: Function to Calculate Factorial of a Number.
What is the difficulty level of this exercise?
Test your Programming skills with w3resource's quiz.
- Weekly Trends and Language Statistics
- Weekly Trends and Language Statistics