postgre sql IF statement code example
Example 1: plpgsql if statement
if condition then
statements;
else
alternative-statements;
END if;
Example 2: postgres if else
DO $$
DECLARE
a integer := 10;
b integer := 20;
BEGIN
IF a > b THEN
RAISE NOTICE 'a is greater than b';
END IF;
IF a < b THEN
RAISE NOTICE 'a is less than b';
END IF;
IF a = b THEN
RAISE NOTICE 'a is equal to b';
END IF;
END $$;