Advertisement
rafibatam

PL/pgSQL IF Statement

Jul 31st, 2019
105
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. DO $$
  2. DECLARE
  3.     brother_age Integer := 20;
  4.     sister_age  Integer := 23;
  5. BEGIN
  6.     IF brother_age > sister_age THEN
  7.         RAISE NOTICE 'Brother is older than Sister';
  8.  
  9.     ELSEIF brother_age < sister_age THEN
  10.         RAISE NOTICE 'Sister is older than Brother';
  11.  
  12.     ELSE
  13.         RAISE NOTICE 'Twins';
  14.     END IF;
  15. END $$;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement