PostgreSQL - PL/pgSQL Fundamentals
What will be the output of the following PL/pgSQL block?
DO $$
DECLARE
temperature INT := 15;
BEGIN
IF temperature >= 30 THEN
RAISE NOTICE 'Hot';
ELSIF temperature >= 20 THEN
RAISE NOTICE 'Warm';
ELSIF temperature >= 10 THEN
RAISE NOTICE 'Cool';
ELSE
RAISE NOTICE 'Cold';
END IF;
END $$;